J
Jim
Hello,
Thanks in advance for the help. I have a worksheet that lists account names
in column A. In column B I have sales from January, column C is sales from
February, Column D is data from March… all the way through to December.
I need help calculating variance’s on the months that double.
For example:
Jan $10
Feb $15 (no variance calculated)
March $15 (no variance calculated)
April $20 (the variance here would be $10 because April doubled January)
May $40 (the variance here would be $20 because May doubled April)
June $45 (no variance calculated)
July $10 (no variance calculated)
Aug $75 (no variance calculated – did not double high month)
Sep $135 (the variance here is $95, because it doubled May)
Oct $150 (no variance calculated)
Nov $250 (no variance calculated)
Dec $270 (the variance here is $135, because it doubled September)
I know this is complex but as I watch the board I’m confident that someone
can help me.
Thanks
Jim
Thanks in advance for the help. I have a worksheet that lists account names
in column A. In column B I have sales from January, column C is sales from
February, Column D is data from March… all the way through to December.
I need help calculating variance’s on the months that double.
For example:
Jan $10
Feb $15 (no variance calculated)
March $15 (no variance calculated)
April $20 (the variance here would be $10 because April doubled January)
May $40 (the variance here would be $20 because May doubled April)
June $45 (no variance calculated)
July $10 (no variance calculated)
Aug $75 (no variance calculated – did not double high month)
Sep $135 (the variance here is $95, because it doubled May)
Oct $150 (no variance calculated)
Nov $250 (no variance calculated)
Dec $270 (the variance here is $135, because it doubled September)
I know this is complex but as I watch the board I’m confident that someone
can help me.
Thanks
Jim