Code Error

[keithb]

Can someone tell me why this code does not work?
I am sure it is something simple, I just can't find it.


mpFormulae(1) = "=SUM(RC[-6] * IF(RC[-5] Range = "Fin", (RC[-2] 1%, 3%)))"

 

[Michael M]

Does it error out at "Fin" ??
I don't have excel at the moment
but try

mpFormulae(1) = "=SUM(RC[-6] * IF(RC[-5] Range = ""Fin"", (RC[-2] 1%, 3%)))"

OR

mp.Formulae(1) = "=SUM(RC[-6] * IF(RC[-5] Range =""Fin"", (RC[-2] 1%, 3%)))"

 

[keithb]

This code works fine.
mpFormulae(1) = "=SUM(RC[-5] * 3%)"

I need this code to be conditional based on the value of another cell.
If 3 columns back ="Fin" I need to multiply the same cell * 1% instead of 3%.
Thank you for your help.

 

[Michael M]

You need to rearrange your formula
Do the IF statement first and then multiply by SUM(RC[-6]

 

[keithb]

Michael M These codes work fine.
mpFormulae(2) = "=SUM(RC[-7] * IF(RC[-7] > 14994, 5%, 6%))"
mpFormulae(3) = "=SUM(RC[-8] * IF(RC[-8] > 14994, 7%, IF(RC[-8] > 10994, 6.5%, IF(RC[-8] > 5598, 3%, 3% ))))"
I thought I could just insert a conditional statement based on "Fin" and then use a different calculation.

 

[keithb]

Michael I tried to re arrange the formula but I still can't make it work, Sorry!
Keith