View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 287
Default need formula help please

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