Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Comparing YTD numbers between last year and present

I am trying to formulate a comparison in different numerical values, ytd
between last year and present, and show the variance in percent change over
or below last year. I am stuck!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default Comparing YTD numbers between last year and present

hi,
Let's suppose that this year information is in cell c6 and last year in B6
=(c6/b6)-1 column has to be formated as %


"LilBeanie1033" wrote:

I am trying to formulate a comparison in different numerical values, ytd
between last year and present, and show the variance in percent change over
or below last year. I am stuck!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing two columns of numbers PaladinWhite Excel Worksheet Functions 2 June 1st 08 11:46 PM
comparing numbers in a sheet Rockbear Excel Discussion (Misc queries) 1 April 15th 08 06:16 PM
Comparing numbers/figures Lona M. Excel Worksheet Functions 1 December 19th 07 02:24 PM
IF statement comparing month and year separately spence Excel Worksheet Functions 6 April 26th 07 10:47 PM
Comparing 3 numbers and displaying the lesser of the three tbible Excel Worksheet Functions 2 November 18th 04 05:41 PM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"