Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What are the most important Excel concepts I should know (will be tested soon)? | Excel Discussion (Misc queries) | |||
Please Help Error 400 when running tested code | Excel Discussion (Misc queries) | |||
Any Nested Function & Condition For Calculating Date & Time | Excel Worksheet Functions | |||
Trouble with condition nested formula | New Users to Excel | |||
What are the most important Excel concepts I should know (will be tested soon)? | Excel Discussion (Misc queries) |