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


"Brenda" wrote in message
...
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?

"Sarah_Lecturer" wrote:

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" wrote:

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" wrote:

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" wrote:

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.