ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I need help with a formula........please (https://www.excelbanter.com/excel-worksheet-functions/230646-i-need-help-formula-please.html)

Wallie

I need help with a formula........please
 
I have an excel worksheet with pricing........I need to formulate the pricing
with an added 7% mark up.

Help..........Thanks!

pdberger

I need help with a formula........please
 
Wallie --

Do you mean you want to mark something up 7%? If so, here's one approach:

A B
1 Cost Price
2 $1 =A2*1.07

However, a better way would be to put your markup percentage in a different
cell, so you can change it any time you want:

A B C D
1 Cost Price Markup 7%
2 $1 =A2*(1+$D$1)


Then you can change all the new prices simply by changing D1.

HTH

"Wallie" wrote:

I have an excel worksheet with pricing........I need to formulate the pricing
with an added 7% mark up.

Help..........Thanks!



All times are GMT +1. The time now is 09:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com