Can I automaticly figure "cost" and sale price in Excel?

T

txwatkinsman

I am trying to formulate spreadsheets to type in the product number,A, Name,
description B, in C I want to type in the amount the item is listed for by my
supplier and have a formula that will automaticly deduct the proper
percentage to arrive at and display the result as my cost. In the next Column
I want the display to be the original list price plus a % to cover shipping
and Tax. The ext column would be # on hand.
I got it to work on the first row but I cant figure out how to do the
formula for column insterad of single cell.



Thank you in advance
 
P

paul

just copy the formula down,xcel will automatically adjust the row and column
references.If you dont want a cell reference to change(say you are
referencing a single cell for the tax and or shipping percentage predede
those with a $ eg $a$1,will always stay as a1 wether you copy down or across

paul
remove nospam for email addy!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top