Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested IF without repeating the condition?
hi everyone
is there a nice elegant way to avoid repeating the same test condition when nesting multiple IF? I mean, my condition is a long formula which must be equal to something. 4 different results are possible. So 3 nested IF. At the moment I write again my long formula to be tested in each IF. If there is a way to use "OR" instead, I could avoid it example: IF(condition=1;true;(if(condition=2;true;(if(condi tion=3;true;.... and so on is there a way to bring "condition" outside??? thanks a lot in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested IF without repeating the condition?
"via sarpi" wrote:
is there a nice elegant way to avoid repeating the same test condition when nesting multiple IF? See responses to the same question in microsoft.public.excel.misc. Please do not multi-post in the future. It causes confusion and forces people to duplicate their responses. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nested IF without repeating the condition to be tested | Excel Discussion (Misc queries) | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Any Nested Function & Condition For Calculating Date & Time | Excel Worksheet Functions | |||
Trouble with condition nested formula | New Users to Excel |