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 |