ExcelBanter - how do i nest more than 15 " if " functions in a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i nest more than 15 " if " functions in a formula (https://www.excelbanter.com/excel-worksheet-functions/27144-how-do-i-nest-more-than-15-%22-if-%22-functions-formula.html)

HARSH BAHAL

how do i nest more than 15 " if " functions in a formula

Pl. help.

Alan

You cant, seven is the limit. You need to rethink and use some kind of
LOOKUP,
Regards,
Alan.
"HARSH BAHAL" <HARSH wrote in message
...
Pl. help.

Max

how do i nest more than 15 " if " functions in a formula
Maybe also take a look at Chip's page:
http://www.cpearson.com/excel/nested.htm
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"HARSH BAHAL" <HARSH wrote in message
...
Pl. help.

All times are GMT +1. The time now is 03:29 PM.