openoffice/excel % advice

[MNuTz]

hi all,

Just a quickie.

I have the following:

column A = Product name
Column B = Item Code
Column C = Standard Price
Column D = Discount

I am trying to work out the cost of a unit with the discount applied but cant figure it out. So in column D i want Standard Price minus Discount = new value.

Can this be done ot will i have to work out what a 5% discount is of the std price in column E and then subtract E from C??

Normally i check my books but i lent them out to a friend!

 

[DAS]

You will have to go for the second option, otherwise Excel will complain about cyclical references.

 

[leezer3]

This should do it (Example formula is for the standard price in cell C2)-

=(C2*0.95)

You'll also need to set the cell type to currency to make the rounding work properly.


I don't see where cyclical references come into it, all you want is 95% of the price in column C.
Unless I've missed something?

-Leezer-

 

[DAS]

Sorry, I think I misunderstood the question. I initially read that the % discount would be in column D (and might vary from 5%) and wanted the end figure also in column D.