Please help with subtraction formula

[Brenda]

I am trying to find a formula that will allow me to subtract .07 from each
products sell price in an order form. The sell price changes every week but
the .07 deduction is always a constant. Is there a way that I can enter a
formula that will address the price change in each specific cell every week
and automatically deduct .07 from it without have to manually subtract it.
(I hope this makes sense to someone). Thank you for reading my request.

 

[Sarah_Lecturer]

Put 0.07 somewhere on the spreadsheet say cell A1

In your formula try (for example) =(B1-$A$1)

This makes A1 Absolute, thus allowing you to copy the formula to other cells
without the A1 location being changed. Hope this helps / is what you were
looking for

Thanks

S ;-)

 

[Brenda]

Okay, I did that and I received a circular reference notice. I followed the
steps and cleared it but it still will not work - Thanks for you suggestion.

 

[Sarah_Lecturer]

If you have a circular reference - did you enter the formula in a blank cell
i.e. where you would like the result to go?

thanks

Sarah

 

[Brenda]

yes.

If you have a circular reference - did you enter the formula in a blank cell
i.e. where you would like the result to go?

thanks

Sarah

 

[Brenda]

I think the issue here is that I need the sum to be in the same cell as the
original product price. There isn't a separate column. Does this make sense?

 

[Sandy Mann]

Brenda,

When you say subtract .07 do you really mean subtract 0.07 or do you mean
take 7% off of the price in that cell?

If the former enter 0.07 in an unused cell then re-select it and copy it.
Next selet the range that you want to change and right-click and select
Paste Special and check "Subtract" in the operation selection.

If you mean take 7% off of the price the enter 0.93 in an unused cell and
repeat the above but check "Multiply" instead of "Subtract"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[JethroUK]

You must put the formula in a seperate column (and keep the original
figures)