Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF and Wizard
Hi I notice when I do the standard IF function using the Wizard I am given
three boxes: Argument True False Is there a way to use the Function Wizard to do a nested IF and if so how do I get more boxes? Many thanks -- Kind regards Ann Shaw |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF and Wizard
When you say "function wizard" what exactly are you referring to? My guess
is most respondents to these posts don't use wizards but rather create their formulas from scratch. Also, if it helps, nested IF functions generally have the form IF THEN ELSE IF THEN ELSE, i.e., =IF(A1=B1,C1+D1,IF(A1=E1,F1+G1,H1+I1)) If A1 equals B1, THEN C1 + D1, ELSE IF A1 equals E1, THEN F1 plus G1, ELSE H1 plus I1. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Annie" wrote: Hi I notice when I do the standard IF function using the Wizard I am given three boxes: Argument True False Is there a way to use the Function Wizard to do a nested IF and if so how do I get more boxes? Many thanks -- Kind regards Ann Shaw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Conditional Sum Wizard | Excel Worksheet Functions | |||
Template Wizard | Excel Discussion (Misc queries) | |||
Allow the use of the fx wizard within the fx wizard for nesting | Excel Worksheet Functions | |||
Wizard | Excel Discussion (Misc queries) |