Need help with whichever is greater formula
 

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

Need help with whichever is greater formula
 

On Jun 21, 12:11*am, Roxy wrote:
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)

Need help with whichever is greater formula
 

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

Cheers!
~Roxy

Need help with whichever is greater formula
 

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


"Roxy" wrote in message ...

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