Home |
Search |
Today's Posts |
#1
|
|||
|
|||
... 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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|