Home

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
hagstrom
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

@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

It seems the picture I added didn’t show up

Formula is

=A1 * (1+B1)

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

@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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies