Thanks

"Paul B" wrote:

Darrell, try this,

=IF((12*C15)/(3.1416*B15)300,300,(12*C15)/(3.1416*B15))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"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