| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF Function not working
This is the formula I put in:
=if(L42<3,"$50",if(L422<5,"$100")). Instead of returning $50 or $100 it returns FALSE. What am I doing wrong? Thank You. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Outlining in nested subtotals not working | Excel Worksheet Functions | |||
| Countif with nested function not working? | Excel Worksheet Functions | |||
| COMPARING DATES with nested IF not working- Syntax is correct though | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Nested IF(AND is not working | Excel Worksheet Functions | |||
Threaded Mode
