Wed 15 May 2013, 13:35Delegate Katy said...
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
Wed 15 May 2013, 15:58
Edited on Wed 15 May 2013, 15:59Trainer Rich said...
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
