=MIN((12*C15)/(3.1416*B15),300)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dr. Darrell" wrote in message
...
I want to display the results a mathmatical equation in a cell unless the
results is greater that 300. If the result is greater than 300 I want to
display 300.

The function is <<< =(12*C15)/(3.1416*B15)

I thought that this is the correct statement, but it doesn't work; <<<
=IF(300(12*C15)/(3.1415*B15),(12*C15)/(3.1415*B15),300)

Could you tell me if I'm on the right track, or could you steer my down
the
correct path?

Darrell