Is there a maximum number of constraints...
....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? |
Is there a maximum number of constraints...
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? |
Is there a maximum number of constraints...
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? |
Is there a maximum number of constraints...
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? |
All times are GMT +1. The time now is 03:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com