If Statements

[jimmye]

Is there anyway that one could use more then 7 if statements in one formulae

[Bryan Hessey]

Is there anyway that one could use more then 7 if statements in one formulae

In B1, if . if. if. if. else C1
In C1 if . If etc

hth
---

[Dav]

There is a limit of 7, and the above wrokround works, but often if you expalin what wants to happen the formula can be simplified or a lookup table can be used to reduce the ifs

so in the following

eg if(a1=1,"a",f(a1=2,"b",if(a1=3,"c",if(a1=4,"d",if(a1=5,"e",#n/a)))))

could if the following was typed in say a10:b14
1 a
2 b
3 c
4 d
5 e

=vlookup(a1,a10:b14,2,false)


Regards

Dav