Forum Discussion
Solved
Return value in IFS based on date
I want to show the spread of monthly spend on a timeline from January 2021 to December 2022. I used 1-24 to put the right value in the right month. I'm having trouble with the following: 1) I use...
Jpalaci1 See attached. I didn't change your approach. Just amended the formula for you. Be aware that you need to use the $ signs in the correct places if you want to be able to drag the formulae across. Note also that you need to test for months from stage 3 down to stage 1. See attached.
Thank you for this. If there was an alternative to this, what would it be in terms of handling the output in a better manner/different approach?
Jpalaci1 You could work with real dates instead of month numbers. That allows you to use some of Excel's built-in date intelligence functions. Added a small example in the attached file. And then there are probably dozens of other thinkable solutions.