Help with formula to add markups based on the cost of the item

%3CLINGO-SUB%20id%3D%22lingo-sub-488247%22%20slang%3D%22en-US%22%3EHelp%20with%20formula%20to%20add%20markups%20based%20on%20the%20cost%20of%20the%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-488247%22%20slang%3D%22en-US%22%3E%3CP%3EHOW%20DO%20I%20WRITE%20A%20FORMULA%20TO%3A%3C%2FP%3E%3CP%3E(a)%20ENTER%20A%20VARIABLE%20NUMBER%20IN%20CELL%20%231%20(%24%20COST)%3B%20THEN%3C%2FP%3E%3CP%3E(b)%20ENTER%20A%20VARIABLE%20DECIMAL%20PERCENTAGE%2C%20eg%200.03%20%2F%203%25%2C%20IN%20CELL%20%232%20(MARKUP)%3B%20RESULTING%20IN%3C%2FP%3E%3CP%3E(c)%20COMBINED%20VALUE%2C%20CELL%20%233%20(RETAIL%20PRICE)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-488247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-488305%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%20to%20add%20markups%20based%20on%20the%20cost%20of%20the%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-488305%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328613%22%20target%3D%22_blank%22%3E%40hagstrom%3C%2FA%3E%26nbsp%3B%2C%20hope%20this%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-488446%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%20to%20add%20markups%20based%20on%20the%20cost%20of%20the%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-488446%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Wyn%2C%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%20I'm%20having%20a%20bit%20of%20difficulty%20understanding%20how%20this%20%22Community%22%20works.%20You%20replied%20'hope%20this%20works'%2C%20but%20I%20don't%20see%20any%20solution%20following%20your%20reply.%20What%20do%20I%20have%20to%20do%20in%20order%20to%20see%20your%20solution%20for%20the%20formula%3F%3C%2FP%3E%3CP%3EEric%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-488739%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%20to%20add%20markups%20based%20on%20the%20cost%20of%20the%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-488739%22%20slang%3D%22en-US%22%3EIt%20seems%20the%20picture%20I%20added%20didn%E2%80%99t%20show%20up%3CBR%20%2F%3E%3CBR%20%2F%3EFormula%20is%3CBR%20%2F%3E%3CBR%20%2F%3E%3DA1%20*%20(1%2BB1)%3CBR%20%2F%3E%3CBR%20%2F%3EWhere%20A1%20contains%20cost%20and%20B1%20has%203%25%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-489105%22%20slang%3D%22en-US%22%3ERE%3A%20Help%20with%20formula%20to%20add%20markups%20based%20on%20the%20cost%20of%20the%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-489105%22%20slang%3D%22en-US%22%3E%D8%A7%D9%84%D8%B3%D9%84%D8%A7%D9%85%20%D8%B9%D9%84%D9%8A%D9%83%D9%85%20%D9%85%D8%A7%D9%87%D9%8A%20%D8%B7%D8%B1%D9%8A%D9%82%D8%A9%20%D8%A7%D9%84%D8%AA%D8%AE%D9%84%D8%B5%20%D9%85%D9%86%20%D8%A7%D9%84%D8%B5%D9%8A%D8%BA%D8%A9%20%D8%A7%D9%88%20%D8%B9%D8%AF%D9%85%20%D8%B1%D8%A4%D9%8A%D8%A9%20%D8%A7%D9%84%D8%B5%D9%8A%D8%BA%D8%A9%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-489163%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20formula%20to%20add%20markups%20based%20on%20the%20cost%20of%20the%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-489163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328613%22%20target%3D%22_blank%22%3E%40hagstrom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20also%20possible%20to%20use%20something%20called%20defined%20names%20in%20place%20of%20cell%20references%2C%20so%20that%20'price'%20becomes%3C%2FP%3E%3CP%3E%3D%20cost%20*%20(%201%20%2B%20markup%20)%3C%2FP%3E%3CP%3EIf%2C%20at%20some%20later%20date%2C%20the%20markup%20were%20to%20differ%20according%20to%20the%20category%20of%20sales%20item%2C%20the%20definition%20of%20'markup'%20would%20change%20but%20the%20formula%20for%20price%20would%20be%20unaltered.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

HOW DO I WRITE A FORMULA TO:

(a) ENTER A VARIABLE NUMBER IN CELL #1 ($ COST); THEN

(b) ENTER A VARIABLE DECIMAL PERCENTAGE, eg 0.03 / 3%, IN CELL #2 (MARKUP); RESULTING IN

(c) COMBINED VALUE, CELL #3 (RETAIL PRICE)

5 Replies
Highlighted
Highlighted

@Wyn Hopkins 

 

Hi Wyn,

Thanks for your reply. I'm having a bit of difficulty understanding how this "Community" works. You replied 'hope this works', but I don't see any solution following your reply. What do I have to do in order to see your solution for the formula?

Eric

Highlighted
It seems the picture I added didn’t show up

Formula is

=A1 * (1+B1)

Where A1 contains cost and B1 has 3%
Highlighted
السلام عليكم ماهي طريقة التخلص من الصيغة او عدم رؤية الصيغة
Highlighted

@hagstrom 

It is also possible to use something called defined names in place of cell references, so that 'price' becomes

= cost * ( 1 + markup )

If, at some later date, the markup were to differ according to the category of sales item, the definition of 'markup' would change but the formula for price would be unaltered.