Hi,
I am trying to set price X using the following formula
(([X]*0.861)+2.43)-[Y]=Z
X=price
Y=cost
Z=profit
what would I have to multiply X by for Z to always be =0.50
I realize this is a math question but I also need to write the formula in Excel.
many thanks,
Elliott
I am trying to set price X using the following formula
(([X]*0.861)+2.43)-[Y]=Z
X=price
Y=cost
Z=profit
what would I have to multiply X by for Z to always be =0.50
I realize this is a math question but I also need to write the formula in Excel.
many thanks,
Elliott