Help! I am getting "you've entered too many arguments for this function- any ideas??

[KCALDERON5894]

Help. I am getting "you've entered too many arguments for this function". Does anyone know how to add more? I am trying to use: =IF(C5<1000001,C15,IF(C5<2000001,C17,IF(C5<3000001,C18,C19,C20,C21))) for the $1.5M , $4M & $5M option but it won't let me add C16, C20 & C21 for column one.[TABLE="width: 287"]
<tbody>[TR]
[TD][/TD]
[TD]B13
[/TD]
[TD]C13
[/TD]
[/TR]
[TR]
[TD]A14
[/TD]
[TD]Options
[/TD]
[TD="align: right"]$1,000
[/TD]
[/TR]
[TR]
[TD]A15
[/TD]
[TD="align: right"]$1,000,000
[/TD]
[TD="align: right"]$1,100
[/TD]
[/TR]
[TR]
[TD]A16
[/TD]
[TD="align: right"]$1,500,000
[/TD]
[TD="align: right"]$1,265
[/TD]
[/TR]
[TR]
[TD]A17
[/TD]
[TD="align: right"]$2,000,000
[/TD]
[TD="align: right"]$1,430
[/TD]
[/TR]
[TR]
[TD]A18
[/TD]
[TD="align: right"]$2,500,000
[/TD]
[TD="align: right"]$1,640
[/TD]
[/TR]
[TR]
[TD]A19
[/TD]
[TD="align: right"]$3,000,000
[/TD]
[TD="align: right"]$1,850
[/TD]
[/TR]
[TR]
[TD]A20
[/TD]
[TD="align: right"]$4,000,000
[/TD]
[TD="align: right"]$2,250
[/TD]
[/TR]
[TR]
[TD]A21
[/TD]
[TD="align: right"]$5,000,000
[/TD]
[TD="align: right"]$2,650
[/TD]
[/TR]
</tbody>[/TABLE]

 

[dispelthemyth]

going through your formula

if C5 < 1,000,001 then be C15 else
If C5 < 2,000,001 then be C17 else
if C5< 3,000,001 then be C18 else be C19


You then have C20 and C21 at the end, which are your invalid arguments, what are you trying to do at the end?

Help. I am getting "you've entered too many arguments for this function". Does anyone know how to add more? I am trying to use: =IF(C5<1000001,C15,IF(C5<2000001,C17,IF(C5<3000001,C18,C19,C20,C21))) for the $1.5M , $4M & $5M option but it won't let me add C16, C20 & C21 for column one.[TABLE="width: 287"]
<tbody>[TR]
[TD][/TD]
[TD]B13[/TD]
[TD]C13[/TD]
[/TR]
[TR]
[TD]A14[/TD]
[TD]Options[/TD]
[TD="align: right"]$1,000[/TD]
[/TR]
[TR]
[TD]A15[/TD]
[TD="align: right"]$1,000,000[/TD]
[TD="align: right"]$1,100[/TD]
[/TR]
[TR]
[TD]A16[/TD]
[TD="align: right"]$1,500,000[/TD]
[TD="align: right"]$1,265[/TD]
[/TR]
[TR]
[TD]A17[/TD]
[TD="align: right"]$2,000,000[/TD]
[TD="align: right"]$1,430[/TD]
[/TR]
[TR]
[TD]A18[/TD]
[TD="align: right"]$2,500,000[/TD]
[TD="align: right"]$1,640[/TD]
[/TR]
[TR]
[TD]A19[/TD]
[TD="align: right"]$3,000,000[/TD]
[TD="align: right"]$1,850[/TD]
[/TR]
[TR]
[TD]A20[/TD]
[TD="align: right"]$4,000,000[/TD]
[TD="align: right"]$2,250[/TD]
[/TR]
[TR]
[TD]A21[/TD]
[TD="align: right"]$5,000,000[/TD]
[TD="align: right"]$2,650[/TD]
[/TR]
</tbody>[/TABLE]

 

[mariopaz18]

Hello,

The IF function only accepts 3 arguments, Value, if value is true, if value is false. If you exceed the amount of "'," (only three accepted per IF) you will get this error. you cannot just put C20,C21 and expect Excel to assume what your are asking for. The formula will need to go to another If funtion to get what you want.

Let me know if this helps, if not, please explain further your needs of the formula.

 

[KCALDERON5894]

going through your formula

if C5 < 1,000,001 then be C15 else
If C5 < 2,000,001 then be C17 else
if C5< 3,000,001 then be C18 else be C19


You then have C20 and C21 at the end, which are your invalid arguments, what are you trying to do at the end?

I am trying to modify someone else's formula ... the formula that was there before was =IF(C5<1000001,C15,IF(C5<2000001,C17,IF(C5<3000001,C18,C19))) and it worked but now I need to add options for $1,500,000 (C16) and the $4,000,000 option (C20) and $5,0000,000 (C21) C5 is where the required Limit will be selected and I want it to calculate the cost. I just don't know how to modify it now that I need to have 7 different options. Any help would be appreciated!

 

[Aladin Akyurek]

i am trying to modify someone else's formula ... The formula that was there before was =if(c5<1000001,c15,if(c5<2000001,c17,if(c5<3000001,c18,c19))) and it worked but now i need to add options for $1,500,000 (c16) and the $4,000,000 option (c20) and $5,0000,000 (c21) c5 is where the required limit will be selected and i want it to calculate the cost. I just don't know how to modify it now that i need to have 7 different options. Any help would be appreciated!

=IF(C5>=1000000,LOOKUP(C5,{1000000,1500000,2000000,3000000,4000000,5000000},C15:C20),0)

Adjust to suit.

 

[KCALDERON5894]

AMAZING! thank you so much for your help! I was losing my mind

 

[Aladin Akyurek]

AMAZING! thank you so much for your help! I was losing my mind

You are welcome. And be careful...