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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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