| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested multiple if
I can not seem to get the syntax right.
=if(AND((A2730,"730),(A2545,A2<730,"545-730"),(A2<365,A2<180,"180-365)))... basically... if 730 then 730 if between 545 and 730 then '545-730 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple nested If statements | Excel Worksheet Functions | |||
| multiple (nested) IF statements | Excel Worksheet Functions | |||
| Multiple (Nested) IF | Excel Discussion (Misc queries) | |||
| multiple nested IF statements | Excel Worksheet Functions | |||
| how do I use multiple nested functions? | Excel Worksheet Functions | |||
Threaded Mode
