IF functions - more than one condition

[Laura R.]

Below is my formula. For this part of the statement: IF(I5=2,E5/40*3, - I
need this to return a minimum number of 3 - can anyone tell me how to adjust
my existing formula to return 3 for this part of the formula (if it's result
is less than 3). Thank you.

=IF(I5="NORM",0,IF(I5=1,E5/8*E5,IF(I5=2,E5/40*3,IF(I5=3,I3/60*2))))

 

[Mike H]

Maybe

=MAX( IF(I5=2,E5/40*3),3)

or the whole formula

=IF(I5="NORM",0,IF(I5=1,E5/8*E5,MAX( IF(I5=2,E5/40*3),3,IF(I5=3,I3/60*2))))

Mike

 

[Max]

For this part of the statement: IF(I5=2,E5/40*3, - I

need this to return a minimum number of 3

Try: IF(I5=2,MAX(3,E5/40*3),

 

[ShaneDevenshire]

Hi,

In addition you may be able to simplify the formula as follows:

=IF(I5="NORM",,IF(I5=1,E5/8*E5,IF(I5=2,MAX(3,E5*0.075),I3*2/60)))

This way you drop the last IF, remove the 0 from the first if and replace a
multiplication and division with just a multiplication.