| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions expert€¦€¦€¦numbering random condition in a column | Excel Worksheet Functions | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Condition 1 overules condition 2? | Excel Worksheet Functions | |||
Linear Mode
