| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement not working
I have an IF Statement to give me a number based on sum of another cell. It
looks like this: =IF($B$5<4000000, "0", IF($B$54000000,"5",IF($B$55000000,"7",IF($B$560 00000,"9",IF($B$57000000,"10"))))) If my number is less than 4000000 it gives me the "0" and if it is greater than 4000000 it gives me "5" but, if the number is greater than 5000000 it still gives me "5" rather than the correct number. Anyone see what I am doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MATCH not working in IF statement | Excel Worksheet Functions | |||
| IF Statement not working | Excel Worksheet Functions | |||
| If statement working only once | Excel Worksheet Functions | |||
| If Statement Not Working | Excel Worksheet Functions | |||
| IF statement not working | Excel Discussion (Misc queries) | |||
Threaded Mode
