| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate variance percetage if figures are negative
I think it is
=abs(A1-B1)/abs(A1) -- Yanick "Jacob Skaria" wrote: Shouldnt that be =(A1-B1)/A1 If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I am trying to calculate the variance percentage in a profit & loss account in excel. I am using the formula (a-b/a)*100, which works ok except when one or both of the figures is negative. The result is showing positive instead of negative and vise-versa. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate variance between numbers? | Excel Worksheet Functions | |||
| display time variance in negative numbers | Excel Discussion (Misc queries) | |||
| graph variance components when 1 is negative | Charts and Charting in Excel | |||
| Editing a column chart for Variance Walk negative numbers | Charts and Charting in Excel | |||
| Can Excel calculate a two sample (pooled) variance? | Excel Discussion (Misc queries) | |||
Hybrid Mode
