I need more than 8 IF functions

S

Steve

I am tryin gto create a formula but need to use more than 8 IF functions in
it. The program will not allow more but I need more, Can anyone suggest how I
may acheive this please

Thanks
 
B

Bob Phillips

Many solutions, tell us the data and the requirement in detail.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
F

Fred Smith

You never need more than 7 nested IFs. There's always a better solution,
typically Vlookup or Index. Post your requirements. You'll get lots of
suggestions.
 
Top