Please help with subtraction formula
yes.
"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.
|