Forum Discussion
Solved
Excel 365 formula to calculate MTD actual vs MTD Budget
I'm working with a YTD P&L and need to calculate a % variance between the latest month numbers and the monthly budget. How can I get the calculation cell to read the latest month entered? In the exa...
Like I did in the attached version of your file, enter this formula in W5:
=LOOKUP(9.9E+307,J5:U5)-V5
This works very well! Thank you. If possible, can you run through the formula explaining each segment? For example, what does "9.9E+307" mean?
9.9E+307 is the highest possible number in Excel. Because it cannot be found in the lookup_vector argument, LOOKUP returns the last number.