Home

Forecasting earlier numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-285061%22%20slang%3D%22en-US%22%3EForecasting%20earlier%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285061%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Excel%20Community%20I%20have%20figures%20from%20Apr%20to%20Oct%20and%20i%20want%20to%20get%20approximate%20figures%20of%20Jan%20to%20Mar%20how%20can%20i%20do%20that%2C%20Need%20help%20and%20logic%20as%20data%20is%20increasing%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20quick%20response%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%26nbsp%3BAccount%2FMonth%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BJan%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BFeb%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BMar%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BApr%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BMay%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BJun%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BJul%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BAug%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BSep%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3BOct%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3BTraveling%20Expense%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2029%2C604%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2037%2C284%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2033%2C581%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2035%2C504%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2044%2C104%3C%2FTD%3E%3CTD%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2044%2C464%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-285061%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288419%22%20slang%3D%22en-US%22%3ERe%3A%20Forecasting%20earlier%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288419%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Dear%2C%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20Forecast%20Function%20is%20giving%20more%20realistic%20values%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285078%22%20slang%3D%22en-US%22%3ERe%3A%20Forecasting%20earlier%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285078%22%20slang%3D%22en-US%22%3E%3CP%3EAnother%20option%20is%20to%20use%20TREND%20function%2C%20but%20it%20requires%20numeric%20X-axis%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20943px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F59494i341B1B4C61DE91F6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285068%22%20slang%3D%22en-US%22%3ERe%3A%20Forecasting%20earlier%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285068%22%20slang%3D%22en-US%22%3E%3CP%3Etry%3A%3CBR%20%2F%3E%3DAVERAGE(F2%3AK2)%3CBR%20%2F%3Efor%20each%20cell%20B%2CC%2CD%2CE%3CBR%20%2F%3Ehope%20this%20helps..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20maybe%3C%2FP%3E%3CP%3E%3DRANDBETWEEN(F2%2CM2)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Muzahir Hussain
New Contributor

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
3 Replies

try:
=AVERAGE(F2:K2)
for each cell B,C,D,E
hope this helps..

 

or maybe

=RANDBETWEEN(F2,M2)

Another option is to use TREND function, but it requires numeric X-axis

image.png

 

Thanks Dear, 

But Forecast Function is giving more realistic values 

Related Conversations