Conditional VBA Error

[keithb]

How do I wright this conditional VBA code?
I cannot make it work.
Any help would be appriciated, I am not good with code.
mpFormulae(1) = "=SUM(RC[-6] * IF(RC[-8] = "Fin", (RC[-2] 1%, 3%)))"

Thanks Keithb

 

[VoG]

It would be something like

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

which compiles but does not look like a valid formula to me. what are you trying to do?

 

[keithb]

VoG I am doing calculations from one cell into other cells @ different amounts. The following codes work:
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% ))))"
mpFormulae(4) = "=SUM(RC[-9] * IF(RC[-9] > 14994, 7%, IF(RC[-9] > 10994, 6.5%, IF(RC[-9] > 5598, 3%, 3% ))))"
The one I am having trouble with is based on a conditional cell containing "Fin", this needs to return a different calculation. If this cell contains "Fin" I need to calculate 1% if the value is different I need it to calculate 3%
Thanks for your help
Keith

 

[VoG]

So should it be?

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

 

[keithb]

Vog that still returns an error.
I think maybe it is not seeing the value of the cell that contains "Fin"
I just don't know enough about these codes to figure it out.
Thanks for you help
keith

 

[VoG]

Does this formula work if you enter it manually?

 

[keithb]

No it doesn't work either way.