•1 min read•from 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!
[link] [comments]
Want to read more?
Check out the full article on the original site