software

....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(I116lt;25,247.84,IF(I116lt;30,256.69,IF(I116lt;35,27 4.39,IF(I116lt;40,295.63,IF(I116lt;45,322.21,IF(I116lt;5 0,354.08,IF(I116lt;55,404.51,IF(I116lt;60,490.7,IF(I11 6lt;65,652.03,IF(I116gt;=65,884.34,N/A))))))))

Excel is giving me an error message at the IF where IF(I116lt;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

www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten

quot;Omakbobquot; gt; wrote in message
...
gt; ...that I can put in an IF formula?
gt; I have a chart with age bands (i.e 20-24, 25-29, 30-35, etc. and
gt; corresponding amounts for those age bands (247.84, 256.69, 274.39,
gt; respectively).
gt;
gt; My current formula reads:
gt;
gt; =IF(I116lt;25,247.84,IF(I116lt;30,256.69,IF(I116lt;35,27 4.39,IF(I116lt;40,295.63,IF(I116lt;45,322.21,IF(I116lt;5 0,354.08,IF(I116lt;55,404.51,IF(I116lt;60,490.7,IF(I11 6lt;65,652.03,IF(I116gt;=65,884.34,N/A))))))))
gt;
gt; Excel is giving me an error message at the IF where IF(I116lt;65,652.03....
gt;
gt; I've double checked to make sure there are no spaces, and when I remove
gt; that
gt; constraint and the ones that follow, the formula works.
gt;
gt; Help?
I didn't answer your original question;

There is a limit of 7 nested functions

--
Kind regards,

Niek Otten

quot;Niek Ottenquot; gt; wrote in message
...
gt; Take a look at the VLOOKUP() function in HELP.
gt;
gt; Or find extra info he
gt;
gt; www.contextures.com/xlFunctions02.html
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Omakbobquot; gt; wrote in message
gt; ...
gt;gt; ...that I can put in an IF formula?
gt;gt; I have a chart with age bands (i.e 20-24, 25-29, 30-35, etc. and
gt;gt; corresponding amounts for those age bands (247.84, 256.69, 274.39,
gt;gt; respectively).
gt;gt;
gt;gt; My current formula reads:
gt;gt;
gt;gt; =IF(I116lt;25,247.84,IF(I116lt;30,256.69,IF(I116lt;35,27 4.39,IF(I116lt;40,295.63,IF(I116lt;45,322.21,IF(I116lt;5 0,354.08,IF(I116lt;55,404.51,IF(I116lt;60,490.7,IF(I11 6lt;65,652.03,IF(I116gt;=65,884.34,N/A))))))))
gt;gt;
gt;gt; Excel is giving me an error message at the IF where IF(I116lt;65,652.03....
gt;gt;
gt;gt; I've double checked to make sure there are no spaces, and when I remove
gt;gt; that
gt;gt; constraint and the ones that follow, the formula works.
gt;gt;
gt;gt; Help?
gt;
gt;
I'll try Vlookup.

Thanks Niekquot;Niek Ottenquot; wrote:

gt; I didn't answer your original question;
gt;
gt; There is a limit of 7 nested functions
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Niek Ottenquot; gt; wrote in message
gt; ...
gt; gt; Take a look at the VLOOKUP() function in HELP.
gt; gt;
gt; gt; Or find extra info he
gt; gt;
gt; gt; www.contextures.com/xlFunctions02.html
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;Omakbobquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; ...that I can put in an IF formula?
gt; gt;gt; I have a chart with age bands (i.e 20-24, 25-29, 30-35, etc. and
gt; gt;gt; corresponding amounts for those age bands (247.84, 256.69, 274.39,
gt; gt;gt; respectively).
gt; gt;gt;
gt; gt;gt; My current formula reads:
gt; gt;gt;
gt; gt;gt; =IF(I116lt;25,247.84,IF(I116lt;30,256.69,IF(I116lt;35,27 4.39,IF(I116lt;40,295.63,IF(I116lt;45,322.21,IF(I116lt;5 0,354.08,IF(I116lt;55,404.51,IF(I116lt;60,490.7,IF(I11 6lt;65,652.03,IF(I116gt;=65,884.34,N/A))))))))
gt; gt;gt;
gt; gt;gt; Excel is giving me an error message at the IF where IF(I116lt;65,652.03....
gt; gt;gt;
gt; gt;gt; I've double checked to make sure there are no spaces, and when I remove
gt; gt;gt; that
gt; gt;gt; constraint and the ones that follow, the formula works.
gt; gt;gt;
gt; gt;gt; Help?
gt; gt;
gt; gt;
gt;
gt;
gt;