Variance formula

bray · #1 04-04-2013, 06:37 AM

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

OTPM · #2 04-04-2013, 07:07 AM

Hi
There are a number of VAR functions in Excel. What kind of data are you wishing to analyse?
Tony

bray · #3 04-04-2013, 09:59 AM

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.

OTPM · #4 04-08-2013, 05:20 AM

Hi Bray
Can I confirm you are comparing with the same periods in the previous year?
Tony

OTPM · #5 04-08-2013, 05:44 AM

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