... If - Then ...

[Guest]

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

 

[peter dmz]

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?

 

[Bob Phillips]

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

--

HTH

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

 

[Paul B]

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

 

[Guest]

Thanks

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

 

[Guest]

Thanks

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?