nesting limitation question...

J

Jim

Hello,

I am using excel 2002 and a formula that uses nesting such as,
"=if(and(vaue1,value2,value3),result1,if(and(value1,value2,value3),result2,if....etc.
My problem is that I am being limited by the ability to nest no more than
seven functions. Is there a way around this? I should add that I am not yet
familiar with VBA programming or user defined functions.

Thanks for any help...

Jim
 
E

Earl Kiosterud

Jim,

Maybe I'm just not awake yet, but if the first IF is satisfied, you'll never
get to the second -- they're the same.
 
J

Jim

Earl....lol...I think I'm the one who's sleepy. You're right; I meant to
write value4,value5,value6, etc....you get the idea.
I TOLD you I need help!

Jim
 
Top