Thanks

"peter dmz" wrote:

What you suggested works fine for me. (You could do it even more simply
though, with the MIN function: =min((12*C15)/(3.1415*B15),300)
Perhaps there is another problem?

"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