Hi,
I'm trying to multiply the result of an IF function combined with a VLOOKUP function by another cell that will change to work out commission rates. My formula is =IF(B9<='Commission Rates'!$A$3,"0",VLOOKUP(B9,'Commission Rates'!$A$2:$B$14,2)) located on cell C9. This formula is working fine and updates anytime I change the figures in B9. I am trying to multiply the answer to this which is a percentage linked to another worksheet by the variable amount in cell B9 and get that answer in cell D9. The only answer that I keep getting is "VALUE".
Please help I have no idea what is going wrong.