| 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 |
| 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 | |||
Threaded Mode
