ExcelBanter - Multiple IF conditions

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Multiple IF conditions (https://www.excelbanter.com/excel-discussion-misc-queries/220001-multiple-if-conditions.html)

Nandu

Multiple IF conditions

Hi
I want to use IF condition more than 7 time (for eg.=if(value,if(eg)), is
there any way?

Max

Multiple IF conditions

"Nandu" wrote:
I want to use IF condition more than 7 time (for eg.=if(value,if(eg)), is
there any way?

It's actually not the IF per se but the nesting depth
You could try a vlookup or an index/match as possibly easier alternatives
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

Harald Staff[_2_]

Multiple IF conditions

http://www.cpearson.com/excel/nested.htm

HTH. Best wishes Harald

"Nandu" wrote in message
...
Hi
I want to use IF condition more than 7 time (for eg.=if(value,if(eg)), is
there any way?

Nandu

Multiple IF conditions

Thanks Max

"Max" wrote:

"Nandu" wrote:
I want to use IF condition more than 7 time (for eg.=if(value,if(eg)), is
there any way?

It's actually not the IF per se but the nesting depth
You could try a vlookup or an index/match as possibly easier alternatives
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---

Max

Multiple IF conditions

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Nandu" wrote in message
...
Thanks Max

All times are GMT +1. The time now is 08:13 AM.