Remember Me?

#1
May 21st 09, 07:06 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: May 2009 Posts: 1
How do I calculate a mark up margin in Excel - price= List - 40%

I would like to build a formular to calculate pricing based on 40% off list.

#2
May 21st 09, 07:30 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2009 Posts: 21
How do I calculate a mark up margin in Excel - price= List - 40%

If price is in cell A1 enter the formula =A1*(1-0.4)
Hope this helps
#3
May 21st 09, 10:04 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 2,819
How do I calculate a mark up margin in Excel - price= List -40%

=A1*0.6

Nanc wrote:
I would like to build a formular to calculate pricing based on 40% off list.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Renae Excel Discussion (Misc queries) 3 February 4th 09 10:08 PM rg2 Excel Worksheet Functions 3 July 28th 07 01:16 AM excel spread sheet Excel Discussion (Misc queries) 0 March 29th 06 06:20 PM Bultgren Excel Worksheet Functions 2 February 14th 06 10:36 AM sdmccabe Excel Worksheet Functions 3 July 4th 05 09:34 PM

All times are GMT +1. The time now is 02:08 PM.