#VALUE ERROR - results from vlookup do not work, manual calculation works

[jgold20]

I am trying to calculate the results of a Vlookup that are returned to a cell and receive a #value error. When I use the formula, it works fine. I have defined the E6 as general:

=IF(AND(D3="yes"),IF(OR(A3={"D","V","X"}),(J9*5%+125),0)). This works

=IF(AND(D3="yes"),IF(OR(A3={"D","V","X"}),(J9*e6),0)) THIS DOES NOT WORK

This is what E6 looks like. - 5%+125

 

[Anthony47]

Of course (J9*5%+125) is not the same than (J9*(5%+125)) (this happens when you put 5%+125 in E6 and then use E6 in the formula)

If you wish to modify both 5% or 125 then you have to use different cells for this purpose (ex: E6 and E7) and then stay with the original formula:

(J9*E6+E7)

Bye