Need help with whichever is greater formula

[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

 

[robzrob]

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

=IF(U3*0.5<1,U3*0.5,1)

 

[Roxy]

Thank you Thank you Thank you!!! You are the best that worked perfectly!

Cheers!
~Roxy

 

[Dana DeLouis]

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