View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Nesting conditional statements

No. You are still contradicting yourself. Please look again at what you
have written and think about what you have said.

In what condition does the 6 apply?
In what condition does the 4 apply?
In what condition does the 3 apply?
And hence in what condition does the 7 apply?
--
David Biddulph

"gcotterl" wrote in message
...
Is these better:

If a1 = 1 then 5, else 6
If a1 = 2 then 9, else 4
if a1 = 4 then 10, else 3
if a1 is not 1 or 2 or 4 then 7