Excel: how to find quotient

[Elliott]

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

 

[Seti]

To always get a profit of .5, X would need to be defined as

[X]=(.5+[Y]-2.43)/0.861

 

[Elliott]

many thanks,

worked great!

Elliott

 

[Elliott]

How would I state this to say, if Price <0 then Price = 0.1, otherwise is:

Price: Round((0.6+[cost]-2.42)/0.861,2)

many thanks,

Elliott

 

[Aladin Akyurek]

How would I state this to say, if Price <0 then Price = 0.1, otherwise is:

Price: Round((0.6+[cost]-2.42)/0.861,2)

many thanks,

Elliott

=MAX(0.1,ROUND(((0.6+A2-2.42)/0.861,2))

where A2 houses the cost value.

 

[Elliott]

How would this be written as an Access Query function?

Many Thanks,

Elliott

 

[Aladin Akyurek]

How would this be written as an Access Query function?

Many Thanks,

Elliott

Price: IIf(Round((0.6+[Cost]-2.42)/0.861,2)<0.1,0.1,Round((0.6+[Cost]-2.42)/0.861,2))

 

[Elliott]

ahh, a gentemen and a scholar

it worked perfectly

MANY THANKS!!

Elliott