It's possible to use IF function 20 times given that you concatenate each
part, however it is hard to audit and if you indeed need many conditions you
might be better off using something else like a lookup table or index,
here's an example of how to bypass the 7 nested limits

=IF( A1=1,"a","")&IF(A1=3,"c","")&IF(A1=5,"e","")&and so on

however you might as well use a vlookup formula

=VLOOKUP(A1,{1,"a";3,"c";5,"e"},2,0)


--
Regards,

Peo Sjoblom

(No private emails please)


"JimB" wrote in message
...
Do you know of any of creating formulas using the "if" function more than
seven times. It is normally limited to seven, I need as many as 20