Dear Community,



I'm trying to build a revenue forecast but got stuck at how to model the annually forecast increase from 2022 to 2023 on the working.

I attached the working sheet and hope someone can provide a guidance please.

Thanks you,
Haha

Attached Files

FM Test.xlsx (32.2 KB, 3 views)

This looks like homework...

Workbook links like:
\Fullstack_Excel Training\Month 6 - Final Assessment\FinalAssessment\Part 1\Sarah's Bakery - Accreditation Case Study BEG.xlsx
are a pretty solid giveaway.

Please don't ask for help with your homework.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,

Thank you for taking the time to review my thread.

I believe there may have been a misunderstanding regarding the intent of my question. I wasn't seeking help to complete the homework in its entirety—rather, I was asking for a single formula to address a specific difficulty I was unable to work through. While I could resort to hard coding, I was hoping for a better solution, which is why I reached out for support.

To be clear, this formula alone does not resolve the rest of the tasks required to complete the assignment.

Thanks.