#1
|
|||
|
|||
Variance formula
HI,
i would like you guys to help me i m trying to do some variance on excel can you help me with a formula that can give me the variance either is negative or positive. Thank you for your help |
#2
|
|||
|
|||
Hi
There are a number of VAR functions in Excel. What kind of data are you wishing to analyse? Tony |
#3
|
|||
|
|||
hi,
i m analysing some sales and compare the data from 1 month, 3 months and one year to see if my sales decrease or increse. |
#4
|
|||
|
|||
Hi Bray
Can I confirm you are comparing with the same periods in the previous year? Tony |
#5
|
|||
|
|||
Hi Bray
Please find herewith a sample not using VAR. Let me know if this suits your needs. Tony |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF formula | MARK SMITH | Excel | 2 | 04-04-2013 01:58 PM |
Finish Variance | ketanco | Project | 1 | 05-14-2012 11:49 AM |
Formula Help - Look and if and that | Corca | Excel | 2 | 02-05-2012 09:18 AM |
Finish Variance in Resouce Usage View | stct | Project | 3 | 05-17-2011 02:07 PM |
Help with Interim Baseline Variance | poyns | Project | 1 | 05-27-2010 10:59 AM |