nested IF without repeating the condition?

V

via sarpi

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(condition=3;true;....
and so on

is there a way to bring "condition" outside???
thanks a lot in advance
 
J

joeu2004

via sarpi said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top