calculate sales price including markup percentage
hello, I have been trying different formulas but nothin worked.
My wholesale price is $395 and my markup is 250 %. How would you calculate that ?
MacBook Pro 15", macOS 10.14
Here are two versions of the calculation:
The two formulas below the table do the same job and produce the same result.
The upper formula is in cell D2.
B2 + B2*C2%
B2 gets the cost value from cell B2. The second B2 gets the same value from B2, x (entered as * ) multiplies that value by the the markup factor in C2, read as a percentage due to the % operator attached to the cell reference, and + adds the two results.
The lower formula is in D4.
B4*(1+C4)
Inside the brackets, 1 is added to the percentage in C4, then B4 is multiplied by the result.
The percent sign, attached to the value in C4 makes Numbers read that value as a percentage, not as an integer value.
Regards,
Barry