Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine if(and statement
Hi,
I would like to combine the following into one formula. Could you please help? Getting frustrated ...:-) =IF(AND(W19=0%,W19<"",W19<25%),"On Plan OVER",IF(AND(W19=-25%,W19<"",W19<0%),"On Plan Under","")) cobine with =IF(W19="","",IF(W190.25,"OVER", IF(W19-0.25,"ON PLAN",IF(W19=0,"n/a","UNDER")))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine if(and statement
What result do you want? Both statements check for virtually the same thing
(eg, 25% and .25 are the same number). Do you want something like: =if(w19="","",if(w19=0,"n/a",if(w1925%,"More than 25%",if(w190,"On Plan Over",if(w19-25%,"On Plan Under","Less than -25%"))))) If not, tell us what result you want for each range of w19. Regards, Fred. " m wrote in message ... Hi, I would like to combine the following into one formula. Could you please help? Getting frustrated ...:-) =IF(AND(W19=0%,W19<"",W19<25%),"On Plan OVER",IF(AND(W19=-25%,W19<"",W19<0%),"On Plan Under","")) cobine with =IF(W19="","",IF(W190.25,"OVER", IF(W19-0.25,"ON PLAN",IF(W19=0,"n/a","UNDER")))) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine if(and statement
You could try using a LOOKUP function:
=IF(W19="","",LOOKUP(W19,{-1,-0.25,0,0.01,0.25},{"UNDER","On Plan Under","N/A","On Plan Over","OVER"})) HTH Elkar " wrote: Hi, I would like to combine the following into one formula. Could you please help? Getting frustrated ...:-) =IF(AND(W19=0%,W19<"",W19<25%),"On Plan OVER",IF(AND(W19=-25%,W19<"",W19<0%),"On Plan Under","")) cobine with =IF(W19="","",IF(W190.25,"OVER", IF(W19-0.25,"ON PLAN",IF(W19=0,"n/a","UNDER")))) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine if(and statement
These two if function give different results for the same criteria, You need
to rework you question. For example: IF(W19-0.25,"ON PLAN" and W19=-25%,W19<"",W19<0%),"On Plan Under" overlap each other?? Also you are check for W19="" and W19<"" this is redundent. (maybe) You are also missing a value for W19=.25 ? Further W18=0 and W19=0 are in conflict. Why make a nice little table <-.25 x =-.25 to <0 y 0 to <.25 z .25 w -- If this helps, please click the Yes button. Cheers, Shane Devenshire " wrote: Hi, I would like to combine the following into one formula. Could you please help? Getting frustrated ...:-) =IF(AND(W19=0%,W19<"",W19<25%),"On Plan OVER",IF(AND(W19=-25%,W19<"",W19<0%),"On Plan Under","")) cobine with =IF(W19="","",IF(W190.25,"OVER", IF(W19-0.25,"ON PLAN",IF(W19=0,"n/a","UNDER")))) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine if(and statement
Hi Shane,
I finally figured it out. Thanks everyone for your help. Have a wonderful day! Thanks, Margie "Shane Devenshire" wrote: These two if function give different results for the same criteria, You need to rework you question. For example: IF(W19-0.25,"ON PLAN" and W19=-25%,W19<"",W19<0%),"On Plan Under" overlap each other?? Also you are check for W19="" and W19<"" this is redundent. (maybe) You are also missing a value for W19=.25 ? Further W18=0 and W19=0 are in conflict. Why make a nice little table <-.25 x =-.25 to <0 y 0 to <.25 z .25 w -- If this helps, please click the Yes button. Cheers, Shane Devenshire " wrote: Hi, I would like to combine the following into one formula. Could you please help? Getting frustrated ...:-) =IF(AND(W19=0%,W19<"",W19<25%),"On Plan OVER",IF(AND(W19=-25%,W19<"",W19<0%),"On Plan Under","")) cobine with =IF(W19="","",IF(W190.25,"OVER", IF(W19-0.25,"ON PLAN",IF(W19=0,"n/a","UNDER")))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine an "IF" and "OR" statement | Excel Worksheet Functions | |||
Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
How to combine IF statement and Vlookup function? | Excel Discussion (Misc queries) | |||
combine IF, AND and OR operstors in a statement | Excel Worksheet Functions | |||
HLookup, IF statement, multiple sort, somehow combine all of these | Excel Worksheet Functions |