•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#Excel compatibility
#rows.com
#cloud-based spreadsheet applications
#Excel
#formula
#annual totals
#projected
#on-pace
#predicts
#total
#sales
#cell
#monthly total
#current date
#10 sales
#value