#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Percentages

Trying to find the percentage difference of the price variance for two line
items then turn it into either a positve or negative percent?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Percentages

Lets say the initial price is in A1 and the final price is in B1. In C1 enter:
=(B1-A1)/A1 and format as %

if the displayed value is positive then we have a price increase
if the displayed value is negative then we have a price decrease
--
Gary''s Student - gsnu200720
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 mike cooke Excel Worksheet Functions 1 November 6th 06 09:03 PM
percentages chedd via OfficeKB.com Excel Worksheet Functions 5 June 12th 06 12:25 PM
Percentages GSTL Excel Discussion (Misc queries) 3 December 4th 05 09:45 PM
Percentages quiddity Excel Discussion (Misc queries) 1 September 13th 05 05:03 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:34 AM.

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"