#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pnw Pnw is offline
external usenet poster
 
Posts: 3
Default PERCENTAGES

Standard Price is $72.75, My discounted price is $30.20, How do I find what my
discount percentage is?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default PERCENTAGES

This is more math than Excel

=(72.75-30.2)/72.75


format as percentage

--


Regards,


Peo Sjoblom

"Pnw" wrote in message
...
Standard Price is $72.75, My discounted price is $30.20, How do I find
what my
discount percentage is?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default PERCENTAGES

Pnw wrote:
Standard Price is $72.75, My discounted price is $30.20, How do I find what my
discount percentage is?



=(72.75-30.20)/72.75
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default PERCENTAGES

A1 = 72.75
B1 = 30.20

=1-(B1/A1)

Format as Percentage

--
Biff
Microsoft Excel MVP


"Pnw" wrote in message
...
Standard Price is $72.75, My discounted price is $30.20, How do I find
what my
discount percentage is?



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


Similar Threads
Thread Thread Starter Forum Replies Last Post
percentages Jen New Users to Excel 1 August 18th 08 01:04 PM
percentages kthornton Excel Discussion (Misc queries) 1 May 30th 06 11:42 PM
Percentages trev2283 Excel Worksheet Functions 1 November 5th 05 06:30 PM
Percentages Vince Carlese Excel Discussion (Misc queries) 9 June 29th 05 09:04 PM
Percentages Darryl Charts and Charting in Excel 2 May 21st 05 04:31 PM


All times are GMT +1. The time now is 10:18 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"