Multiple IF conditions

N

Nandu

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

Max

Nandu said:
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
---
 
Top