problem with parenthesis with multiple ifs - too many arguements for this funciton

[Pumpk1n]

[TABLE="width: 661"]
<tbody>[TR]
[TD="colspan: 2"]=if(BL4=.46,0),[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]if(cu4=1,(vlookup(bl4,Grids!$D$70:$E$80,2)),[/TD]
[/TR]
[TR]
[TD="colspan: 3"]if(cu4=50,(vlookup(bl4,Grids!$D$70:$e$80,2),[/TD]
[/TR]
[TR]
[TD="colspan: 3"]if(ai4=10,(vlookup(bl4,Grids!D$$101:$E$113,2)),[/TD]
[/TR]
[TR]
[TD="colspan: 3"]if(ai4<6,(vlookup(bl4,Grids!$D$70:$E$80,2)),[/TD]
[/TR]
[TR]
[TD="colspan: 3"]if(ai6<=9,(vlookup(bl4,Grids!$D$85:$E$96,2)))))) Help! [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="2"><col></colgroup>[/TABLE]

 

[pkdeimos]

Hi,

Can you please try this?

=IF(BL4=0.46,0,
IF(CU4=1,(VLOOKUP(BL4,Grids!$D$70:$E$80,2)),
IF(CU4=50,(VLOOKUP(BL4,Grids!$D$70:$E$80,2)),
IF(AI4=10,(VLOOKUP(BL4,Grids!D$101:$E$113,2)),
IF(AI4<6,(VLOOKUP(BL4,Grids!$D$70:$E$80,2)),
IF(AI6<=9,(VLOOKUP(BL4,Grids!$D$85:$E$96,2))))))))

On another note, i believe this can be optimised. Any context around the formula?

Regards.

 

[Pumpk1n]

Thanks- this worked. There's a bunch of different scenarios we need to check for rates, so each of the "if" conditions is a condition to look up the value. I know that is vague, but it's the reason we have the various scenarios.

Hi,

Can you please try this?

=IF(BL4=0.46,0,
IF(CU4=1,(VLOOKUP(BL4,Grids!$D$70:$E$80,2)),
IF(CU4=50,(VLOOKUP(BL4,Grids!$D$70:$E$80,2)),
IF(AI4=10,(VLOOKUP(BL4,Grids!D$101:$E$113,2)),
IF(AI4<6,(VLOOKUP(BL4,Grids!$D$70:$E$80,2)),
IF(AI6<=9,(VLOOKUP(BL4,Grids!$D$85:$E$96,2))))))))

On another note, i believe this can be optimised. Any context around the formula?

Regards.