Hi all I am very new to Excel so forgive my lack of knowledge, I have a catalog worksheet of auto parts with descriptions part numbers and prices, my problem is I want to creat a cloumn that will show me my discount my discount value is 37.5% any help would be appreciated
Thanks Phil
If your price is in A1, try this in B1
=A1*37.5% format to Currancy - discount
or
=A1-A1*37.5% - discounted price
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
is it possible to format the entire column that way or is there another way?
To copy drag the Fill Handle down as far as neededOriginally Posted by seaterphil
You can use the fill handle, these links explain the fill handle
http://www.jegsworks.com/Lessons/num...s/autofill.htm
http://www.mistupid.com/viewlets/excel/xlautofill.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks