Nov 11 2018 12:03 AM
Dear Excel Community I have figures from Apr to Oct and i want to get approximate figures of Jan to Mar how can i do that, Need help and logic as data is increasing
Thanks for your quick response
Account/Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct |
Traveling Expense | 29,604 | 37,284 | 33,581 | 35,504 | 44,104 | 44,464 |
Nov 11 2018 02:57 AM - edited Nov 11 2018 03:49 AM
try:
=AVERAGE(F2:K2)
for each cell B,C,D,E
hope this helps..
or maybe
=RANDBETWEEN(F2,M2)
Nov 11 2018 04:43 AM
Another option is to use TREND function, but it requires numeric X-axis
Nov 18 2018 06:03 AM
Thanks Dear,
But Forecast Function is giving more realistic values