Create a sheet with one explicit pricing convention
To calculate selling price from markup in Excel or Google Sheets, use =A2*(1+B2) when A2 contains cost and B2 contains a numerical percentage such as 35%. To recover markup from a known selling price, use =(price-cost)/cost and display the result as a percentage. These formulas use cost as the denominator. Label the rate column Markup on cost so a user does not enter a desired margin there by mistake.
Use one currency and the same unit quantity for cost and price. A cost per individual item cannot be compared directly with the selling price of a carton. The cost definition must also be stated; the workbook cannot decide which expenses belong in it. This educational worksheet explains arithmetic on supplied assumptions, rather than prescribing commercial rates, financial-reporting classifications or the price customers will accept.
Lay out a reproducible input and output row
Put Cost in A1, Markup in B1, Selling price in C1, and Excess over cost in D1. Enter 28 in A2 and 35% in B2. In C2 type =A2*(1+B2); in D2 type =C2-A2. The results are 37.80 and 9.80 before any separately modelled expenses. The factor 1.35 preserves the original 28 and adds 35% of it, rather than calculating only the added amount.
To verify the row, use =(C2-A2)/A2 in E2 and format it as Percentage. It returns 35%. The full price divided by cost, =C2/A2, returns factor 1.35, not the markup rate. Keeping those two checks in separate labelled columns prevents one from being displayed with the other's title. Decide which check is useful for the sheet and avoid allowing downstream formulas to infer meaning from cell formatting alone.
Keep percentage storage consistent across platforms
Type 35% explicitly rather than a plain 35 if the formula is =A2*(1+B2). The stored fraction is 0.35. If the worksheet intentionally stores a whole-number percent such as 35, change the formula to =A2*(1+B2/100). Do not divide a genuine 35% cell by 100 again; that would apply only 0.35% markup and yield 28.098 instead of 37.80. Both input conventions work when used consistently.
In Excel, use percentage formatting for rate outputs and an appropriate numerical or currency format for amounts. In Google Sheets, apply the corresponding options under Format, Number. The formulas here use English-style names and argument separators; adjust to the workbook locale where required. A leading apostrophe or imported text suffix can leave a cell nonnumeric even when it looks like a percentage. Check its numerical status before trusting the derived price.
Treat a target margin as a separate calculation
If B2 instead represents a target share of selling price retained above cost, the formula is =A2/(1-B2), not =A2*(1+B2). At cost 28 and a target margin of 35%, the unrounded selling price is approximately 43.076923077. That differs from the 37.80 produced by 35% markup. Give the margin calculation its own labelled input or a clearly controlled mode rather than letting the same column change meaning silently.
For a positive selling price in C2, =(C2-A2)/C2 calculates the price-based margin. Applied to the markup example, it gives approximately 25.9259259%. A target margin of 100% with positive cost has no finite solution. Flag that request rather than returning zero through a generic error handler. The related markup-versus-margin guide explains the denominator distinction; this worksheet keeps the implementation explicit so copied formulas follow the intended rate.
| Question | Formula | Cost 28 and rate 35% |
|---|---|---|
| Price from markup | =A2*(1+B2) | 37.80 |
| Recover markup from price | =(C2-A2)/A2 | 35% when C2 = 37.80 |
| Price from target margin | =A2/(1-B2) | 43.076923077 before rounding |
B2 is a percentage-valued cell. The numerator and denominator must refer to compatible prices and quantities.
Anchor shared rates and review copied formulas
A shared markup stored in H1 can be applied with =A2*(1+$H$1). The absolute reference keeps H1 fixed as the formula is copied downward, while A2 moves to A3, A4 and subsequent cost rows. If each product instead has its own B-column markup, leave B2 relative. Test a second row with a different cost so an accidentally shifted reference cannot hide behind identical example values.
For example, cost 40 at the same 35% shared markup gives price 54 and excess 14. If that row accidentally reads an empty H2 as zero, it could return 40 and look like a deliberate no-markup price. Review references, validate required inputs and distinguish a valid entered zero rate from a missing rate. A correctly calculated first row is evidence about that row, not proof that every copied row uses the right cells.
Flag invalid costs and preserve undefined ratios
A positive cost is required for a meaningful cost-based markup ratio. One guarded price formula is =IF(AND(ISNUMBER(A2),ISNUMBER(B2),A2>0,B2>=-1),A2*(1+B2),NA()). This explicit convention allows prices at or above zero and flags invalid inputs. Additional upper bounds may be appropriate for the sheet. A blank cost should not become a valid free product, and an IFERROR wrapper returning zero should not hide a missing denominator.
A zero selling price with positive cost gives −100% markup but an undefined price-based margin. A positive price below cost gives negative markup and negative margin, which may be a meaningful loss scenario. The website accepts costs from 0.01 within its supported range, while a workbook can define other valid measurement scales. Align the assumptions before comparing outputs, and do not treat the website's numeric limits as commercial or accounting rules.
Specify whether the computed price is rounded
Currency formatting generally changes display rather than the underlying value. To make a rounded two-decimal price feed later formulas, use =ROUND(A2*(1+B2),2). For cost 19.95 and markup 30%, the unrounded price is 25.935 and the deliberately rounded result is 25.94. That rounded selling price implies a recovered markup of approximately 30.0250627%, slightly above the original target. Record both the target rate and the realized rate if the distinction matters.
Do not overwrite the target with a rounded reverse check and then assume it was the originally chosen percentage. Discounts, selling fees and taxes also belong in clearly separate columns or models. A 35% markup calculation alone cannot determine net profit. The cost field defines what the difference covers, while omitted amounts remain outside the row. Rounding rules can differ between systems, so compare the documented numerical policy as well as the displayed result.
Audit supported examples against the Markup Calculator
Choose cost-and-markup mode on NumUtility, enter cost 28 and whole-number markup 35, and confirm price 37.80, excess 9.80 and margin near 25.9259259%. The spreadsheet input was 35%, while the website asks for 35 in its percent field. Then choose cost-and-price mode with 28 and 37.80 to verify the recovered rate. Re-enter the intended figures after changing modes because example values are loaded.
Keep a small worksheet check set: zero markup returns cost, doubling cost implies 100% markup, a zero cost is rejected for the ratio, and a zero selling price leaves margin undefined. Save the cost basis, units, percentage convention and rounding choice with the workbook. These checks make formulas reviewable after future edits without presenting an educational spreadsheet as an automated pricing strategy or a source of verified business costs.