Still using Excel 2000. How to nest more than 7 in IF formula

[Granny-G]

How do I nest more than 7 arguments in an IF formula ?
Most HELP info is too cryptic for me to understand.

Thanks.

 

[Niek Otten]

Look here:

http://spreadsheetpage.com/index.php/tip/alternatives_to_nested_if_functions

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I nest more than 7 arguments in an IF formula ?
| Most HELP info is too cryptic for me to understand.
|
| Thanks.