IF STATEMENT

[Guest]

Does anyone know if it is possible to create an IF statement longer than a
string of 7 arguements, if so how?

 

[Niek Otten]

Look here:

http://www.j-walk.com/ss/excel/usertips/tip080.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Does anyone know if it is possible to create an IF statement longer than a
| string of 7 arguements, if so how?

 

[Geoff Ness]

It's not possible to nest more than 7 IF statements, but there are
workarounds. One can be found at http://www.cpearson.com/excel/nested.htm

and another at http://www.grbps.com/ExcelA.pdf

Hope this helps