Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-04-2013, 06:37 AM
bray bray is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Mar 2013
Posts: 7
bray is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 04-04-2013, 07:07 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 975
OTPM is on a distinguished road
Default

Hi
There are a number of VAR functions in Excel. What kind of data are you wishing to analyse?
Tony
Reply With Quote
  #3  
Old 04-04-2013, 09:59 AM
bray bray is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Mar 2013
Posts: 7
bray is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 04-08-2013, 05:20 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 975
OTPM is on a distinguished road
Default

Hi Bray
Can I confirm you are comparing with the same periods in the previous year?
Tony
Reply With Quote
  #5  
Old 04-08-2013, 05:44 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 975
OTPM is on a distinguished road
Default

Hi Bray
Please find herewith a sample not using VAR.
Let me know if this suits your needs.
Tony
Attached Files
File Type: xlsx Sales ANalysis.xlsx (17.2 KB, 1 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 06:40 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft