IF functions - more than one condition
 

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))))
--
Laura R.

IF functions - more than one condition
 

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

"Laura R." wrote:

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))))
--
Laura R.

IF functions - more than one condition
 

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),
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Laura R." wrote:
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))))
--
Laura R.

IF functions - more than one condition
 

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.

--
Cheers,
Shane Devenshire


"Laura R." wrote:

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))))
--
Laura R.