Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fine tuning if statement....
I think that something is missing but this is the formula I need.
=IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N40.125%,"Run Time Too Short","Run Time OK")) But here is the problem the true statements work fine but the false statement does not work. What I am a trying to get is if the false statement which is o4-n4<0.125% so anything that falls between o4-n4<0.125% Run Time OK. Any suggestions would be great. thanks in advance for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fine tuning if statement....
-----Original Message----- I think that something is missing but this is the formula I need. =IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N40.125%,"Run Time Too Short","Run Time OK")) But here is the problem the true statements work fine but the false statement does not work. What I am a trying to get is if the false statement which is o4-n4<0.125% so anything that falls between o4-n4<0.125% Run Time OK. Any suggestions would be great. thanks in advance for the help. . I think that you need to do : =if((o4-n4)<0.00125,"Run Time OK","Runtime too long") I didnt fully understand your situation, but the above, will if the differnce between O and N is anything other than 0.125% then its OK otherwise too long. Hope this helps Nath. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fine tuning if statement....
Derek,
Before the logic of you formula, what values of "O4-N4" are you expecting and (more importantly) what is the user seeing, with the formatting of those cell. e.g. Really O4-N4=0.1249999999999999 but is shown as 0.125. Do you consider these equal ? NickHK "Derek Witcher" wrote in message om... I think that something is missing but this is the formula I need. =IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N40.125%,"Run Time Too Short","Run Time OK")) But here is the problem the true statements work fine but the false statement does not work. What I am a trying to get is if the false statement which is o4-n4<0.125% so anything that falls between o4-n4<0.125% Run Time OK. Any suggestions would be great. thanks in advance for the help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fine tuning if statement....
What I am looking for is if the difference of O4-N4 is greater than .125% give result if greater that .125% another result and if these (2) fail then give another. =IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N40.125%,"Run Time Too Short","Run Time OK")) This formula works for the True results but for the false result does not work. So what I am looking for is if my data falls within that <.125% to give true result. Any suggestions on other ways would be fine as well. Thanks for all help given. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fine tuning if statement....
Derek,
Your works as expected if: O4 & N4 are formatted as percentages As said before O4-N4= EXACTLY 0.125%, not merely appearing to. However, I'm still confused as to what "So what I am looking for is if my data falls within that <.125% to give true result" . A diiference of 0.125% should return "Run Time OK" ? NickHK "Derek Witcher" wrote in message ... What I am looking for is if the difference of O4-N4 is greater than 125% give result if greater that .125% another result and if these (2) fail then give another. =IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N40.125%,"Run Time Too Short","Run Time OK")) This formula works for the True results but for the false result does not work. So what I am looking for is if my data falls within that <.125% to give true result. Any suggestions on other ways would be fine as well. Thanks for all help given. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fine tuning if statement....
-----Original Message----- I think that something is missing but this is the formula I need. =IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N40.125%,"Run Time Too Short","Run Time OK")) But here is the problem the true statements work fine but the false statement does not work. What I am a trying to get is if the false statement which is o4-n4<0.125% so anything that falls between o4-n4<0.125% Run Time OK. Any suggestions would be great. thanks in advance for the help. . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fine tuning if statement....
try starting at the top. an example
=IF(C35,"a",IF(C34,"b",IF(C33,"c","d"))) -- Don Guillett SalesAid Software wrote in message ... -----Original Message----- I think that something is missing but this is the formula I need. =IF(O4-N4<0.125%,"Run Time Too Long",IF(O4-N40.125%,"Run Time Too Short","Run Time OK")) But here is the problem the true statements work fine but the false statement does not work. What I am a trying to get is if the false statement which is o4-n4<0.125% so anything that falls between o4-n4<0.125% Run Time OK. Any suggestions would be great. thanks in advance for the help. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro fine Run fine from Select but not from KB Shortcut? | Excel Discussion (Misc queries) | |||
help w/ fine tuning | New Users to Excel | |||
Fine-tuning selection change event for merged cells & wrap text | Excel Programming | |||
Tuning Off Toolbars | Excel Programming | |||
Refresh & backup tuning! | Excel Programming |