....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,27 4.39,IF(I116<40,295.63,IF(I116<45,322.21,IF(I116<5 0,354.08,IF(I116<55,404.51,IF(I116<60,490.7,IF(I11 6<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?

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

Or find extra info he

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

--
Kind regards,

Niek Otten

"Omakbob" wrote in message
...
...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,27 4.39,IF(I116<40,295.63,IF(I116<45,322.21,IF(I116<5 0,354.08,IF(I116<55,404.51,IF(I116<60,490.7,IF(I11 6<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?

I didn't answer your original question;

There is a limit of 7 nested functions

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
Take a look at the VLOOKUP() function in HELP.

Or find extra info he

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

--
Kind regards,

Niek Otten

"Omakbob" wrote in message
...
...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,27 4.39,IF(I116<40,295.63,IF(I116<45,322.21,IF(I116<5 0,354.08,IF(I116<55,404.51,IF(I116<60,490.7,IF(I11 6<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?

I'll try Vlookup.

Thanks Niek


"Niek Otten" wrote:

I didn't answer your original question;

There is a limit of 7 nested functions

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
Take a look at the VLOOKUP() function in HELP.

Or find extra info he

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

--
Kind regards,

Niek Otten

"Omakbob" wrote in message
...
...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,27 4.39,IF(I116<40,295.63,IF(I116<45,322.21,IF(I116<5 0,354.08,IF(I116<55,404.51,IF(I116<60,490.7,IF(I11 6<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?