Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What am I doing wrong?
Here is the formula I came up with but it doesn't do what I want it to.
=IF(C247.999,IF(D2143.999,"22222",IF(C2<47.998,I F(D2<143.998,"33333")))) If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222" (this is what i want), but when I type anything lower in either column it returns "FALSE". I want it to return "33333". In other words, I want it to return "22222" only when both C2 and D2 are true, but when either one of them are not true, I want "33333" returned. Thank you, Jeff |
#2
|
|||
|
|||
You have one guess at your post in .misc.
Jeff wrote: Here is the formula I came up with but it doesn't do what I want it to. =IF(C247.999,IF(D2143.999,"22222",IF(C2<47.998,I F(D2<143.998,"33333")))) If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222" (this is what i want), but when I type anything lower in either column it returns "FALSE". I want it to return "33333". In other words, I want it to return "22222" only when both C2 and D2 are true, but when either one of them are not true, I want "33333" returned. Thank you, Jeff -- Dave Peterson |
#3
|
|||
|
|||
=IF(AND(C247.999,D2143.999),"22222","33333")
Regards Bill K "Jeff" wrote in message ... Here is the formula I came up with but it doesn't do what I want it to. =IF(C247.999,IF(D2143.999,"22222",IF(C2<47.998,I F(D2<143.998,"33333")))) If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222" (this is what i want), but when I type anything lower in either column it returns "FALSE". I want it to return "33333". In other words, I want it to return "22222" only when both C2 and D2 are true, but when either one of them are not true, I want "33333" returned. Thank you, Jeff |
#4
|
|||
|
|||
=1111*(OR(C2<48,D2<144)+2)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Jeff" wrote in message ... Here is the formula I came up with but it doesn't do what I want it to. =IF(C247.999,IF(D2143.999,"22222",IF(C2<47.998,I F(D2<143.998,"33333")))) If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222" (this is what i want), but when I type anything lower in either column it returns "FALSE". I want it to return "33333". In other words, I want it to return "22222" only when both C2 and D2 are true, but when either one of them are not true, I want "33333" returned. Thank you, Jeff |
#5
|
|||
|
|||
Thanks,
Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's wrong with this vb? | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
multi-level subtotals are in the wrong position | Excel Worksheet Functions | |||
Logic statement returns wrong answer. | Excel Worksheet Functions | |||
IF function displays wrong amount | Excel Worksheet Functions |