View Single Post
  #1   Report Post  
Dr. Darrell
 
Posts: n/a
Default ... If - Then ...

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