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.

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.

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.

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.

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.

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.

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


Replace @mailinator.com with @tiscali.co.uk


"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.

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.