Hi everyone, Newbie here!
OK so I'm sure you expert and even somewhat novice users will be rolling your eyes after reading my question, but although I would classify myself as a 'Word' Expert.... Believe it or not this is the First time I’ve tried to use ANY version of Excel.... so I'm like a newborn trying to find the.....Ummm...TEET.. for the first time!...Sorry, I have a twisted sense of humor!
So I have Excel 2010 and since my Abacus broke I figured what the heck, I'll give it a shot. I need to create a sheet for my online sales business that shows Cost to buy, Price Sold, Profit made and Profit Margin.....For the profit margin I want to use SELLING PRICE profit margin Not COST profit margin. (R=P/B) Where R is "Rate", or aka Selling Price Profit margin.... P is "Mark-Up", or aka Profit made ...... and B is "Base", or aka Selling price that I sold the item for. So I want to use that formula for the Profit Margin portion of the sheet but I still want the simple function of 'Cost' Minus 'Sell price' to see 'Profit made' then flow right into the profit margin colum.
I have tried searching Google but apparently the Abacus industry isn't fairing too well in this economy b/c I found No replacement parts for mine.... Oh ya, and I also searched for info on how to create this sheet but I must be missing something because I've tried to enter the formulas in the cells....but don't think I'm entering them in the right cells or maybe not entering them as a formula....Hell I don't know, that’s why I'm here!
Remember.... I am that Newbie so please don’t assume I know 'Where' or 'How' to enter a formula into excel at all.....Cause I don’t…...and NO I do NOT droll on myself (not everyday anyway) I do Not require a care taker nor am I required to wear a helmet full time in life due to a lack of Brain cells….I’m just unfamiler to this Fancy, new-fangled program you guys call ‘Excel’.
I HATE when people ask questions like mine, so sorry about being “That Guy” and not searching the form but I did try that briefly and am in a HUGE hurry therefore I don't have the time to search any longer. THANK YOU IN ADAVANCE for any and all help!!
In the future, maybe I can return the favor to one of you……I am a certified Electrician so Just let me know if you have any wiring related questions.... and I'll be sure to lecture you on even attempting it in the first place (JK)....Also, as I'm sure you may have suspected, Yes I do indeed have a Degree in Sarcasm and furthermore I have been a certified, practicing, Smart A-s-s for like.... Geeze... must be 15 years now... so I May even be able to help you with that as well!
All joking aside….Thanks Again for any help
DJ
Bookmarks