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

"Lady J" wrote:


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

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 EditPaste SpecialAddOKEsc

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

On Thu, 26 Jul 2007 17:04:00 -0700, Lady J <Lady
wrote:


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

thank you very much, it works :)

"daddylonglegs" wrote:

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

"Lady J" wrote:


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