need formula help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need the forumula to add 300 to the Wholesale (R8) and the answer be in
Markup Price (S8)

i need to do this all the lines tho
B R S
AG

item Wholesale Markup Price Additional
notes

line 8 item 8666 8966
line 9 1499 1799
line 10 5250 5550
line 11 678 978
 
Hello Lady J,

Try using this formula in S8

=R8+300

then drag the formula down the column, or use the fill handle to fill down
automatically. Place cursor on bottom right corner of cell until you see a
black + sign (this is the "fill-handle"). Double click the fill handle and
the formula will be replicated down column S for as far as you have data in
column R
 
daddylonglegs has provided a formula in his post.

If this is a one time operation and you didn't want a formula you could enter
300 in an empty cell.

Copy that cell.

Select column S and Edit>Paste Special>Add>OK>Esc

But how come the markup is 300 on all Wholesale costs. Seems a little low on
8666

Note with the formula............if you have a floating markup you could enter
that number in a cell and use the formula so's all you have to do is change the
number in the one cell.

Say you have 300 in T1

=R8 + $T$1 copied down column S


Gord Dibben MS Excel MVP
 
thank you very much, it works :)

daddylonglegs said:
Hello Lady J,

Try using this formula in S8

=R8+300

then drag the formula down the column, or use the fill handle to fill down
automatically. Place cursor on bottom right corner of cell until you see a
black + sign (this is the "fill-handle"). Double click the fill handle and
the formula will be replicated down column S for as far as you have data in
column R
Click to expand...
 
Back
Top