if function multiple

AI Training: For Busy Decision Makers & Professionals Book now

Forum 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

resolvedResolved · 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

Edited on Wed 15 May 2013, 15:59

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


 

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips


Server loaded in 0.12 secs.