Is there a maximum number of constraints...

[Guest]

....that I can put in an IF formula?
I have a chart with age bands (i.e 20-24, 25-29, 30-35, etc. and
corresponding amounts for those age bands (247.84, 256.69, 274.39,
respectively).

My current formula reads:

=IF(I116<25,247.84,IF(I116<30,256.69,IF(I116<35,274.39,IF(I116<40,295.63,IF(I116<45,322.21,IF(I116<50,354.08,IF(I116<55,404.51,IF(I116<60,490.7,IF(I116<65,652.03,IF(I116>=65,884.34,N/A))))))))

Excel is giving me an error message at the IF where IF(I116<65,652.03....

I've double checked to make sure there are no spaces, and when I remove that
constraint and the ones that follow, the formula works.

Help?

 

[Niek Otten]

Take a look at the VLOOKUP() function in HELP.

Or find extra info here:

http://www.contextures.com/xlFunctions02.html

 

[Niek Otten]

I didn't answer your original question;

There is a limit of 7 nested functions

 

[Guest]

I'll try Vlookup.

Thanks Niek

I didn't answer your original question;

There is a limit of 7 nested functions