1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel formula for projected annual totals

Hi there, does anyone know how to make an Excel formula which takes a number found in one cell and then predicts, based on the current date, the "on-pace for the year" total that that cell might suggest? For example, if its January 31st and I have 10 sales, then the on-pace formula would take that "10" number and give me a total of 120 (10 x 12 months). I can't seem to figure it out. Thanks for any help you can provide!

submitted by /u/authoraaronryan
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article