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 |
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 |
=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 |
=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 |
Thanks,
Jeff |
All times are GMT +1. The time now is 07:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com