Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
percentages | Excel Worksheet Functions | |||
percentages | Excel Worksheet Functions | |||
Percentages | Excel Discussion (Misc queries) | |||
Percentages | Excel Discussion (Misc queries) | |||
Percentages | Charts and Charting in Excel |