Need help with whichever is greater formula

  • Thread starter Thread starter Roxy
  • Start date Start date
R

Roxy

I have a worksheet in MS2003 and need to have a cell preform the following
function:
Multiply cell U3 by .05 or display 1 whichever is greater.

Any help is greatly appreciated, thanks in advance!

~Roxy
 
I have a worksheet in MS2003 and  need to have a cell preform the following
function:
Multiply cell U3 by .05 or display 1 whichever is greater.

Any help is greatly appreciated, thanks in advance!

~Roxy
Click to expand...



=IF(U3*0.5<1,U3*0.5,1)
 
Multiply cell U3 by .05 or display 1 whichever is greater.

Another option is to take the "maximum" of the two values.

=MAX(U3*0.05, 1)

--
HTH :>)
Dana DeLouis
 
Back
Top