... 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

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

=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

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

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

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