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

[Pumpk1n]

=if(BL4=.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)))))) Help!

<tbody>
</tbody><colgroup><col span="2"><col></colgroup>

 

[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.