| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing two columns of numbers | Excel Worksheet Functions | |||
| comparing numbers in a sheet | Excel Discussion (Misc queries) | |||
| Comparing numbers/figures | Excel Worksheet Functions | |||
| IF statement comparing month and year separately | Excel Worksheet Functions | |||
| Comparing 3 numbers and displaying the lesser of the three | Excel Worksheet Functions | |||
Hybrid Mode
