Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 258
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"