View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Laura R. Laura R. is offline
external usenet poster
 
Posts: 1
Default 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.