98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » IF function - multiple conditions need to be met | Excel forum
IF function - multiple conditions need to be met | Excel forum
Resolved · Urgent Priority · Version 2010
Katy has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
IF function - multiple conditions need to be met
Hi all
I am trying to create a formula where by if a number that is entered is between 1 and 25, it must display the word "PRE" and for numbers over that amount it must display the word "POST".
I created a formula that seemed to work correctly, however I want the field to be left blank if there is nothing entered in the number field.
Would you be able to help?
Many thanks
Katy
RE: IF function - multiple conditions need to be met
Hi Katy,
Thanks for your question. I hope you enjoyed the Excel Advanced training.
Assuming your data is in cell A1, what about this formula?
=IF(AND(A1>=1,A1<=25),"PRE",IF(AND(A1>25, ISNUMBER(A1)),"POST",""))
This first checks if the number is between 1 & 25, displayed 'PRE' if true. If it's false, it does another If statement to see if it's over 25 and is numeric. If true displays 'POST', otherwise displays blank ('').
This is called Nested IF statements.
If this answer resolves your query, please mark the question as 'resolved' (see below). Otherwise, please post a follow-up response to this post, and I will assist you further.
Regards, Rich
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Equations in Excel 2010Here's how to create basic mathematical |