Forum Discussion
need help
I am trying create an if statement whereby Column AH, row 4, computes total expense YTD depending on the quarterly date on C1, so that the following is done…. If C1= 03/31/2023, Column AH, row ...
For example:
=CHOOSE(MONTH($C$1)/3,S4,S4+V4,S4+V4+Y4,S4+V4+Y4+AB4)
or
=S4+(MONTH($C$1)>5)*V4+(MONTH($C$1)>8)*Y4+(MONTH($C$1)>11)*AB4
Remark: please correct the date in Input!B15
- Hans
-- Thank you so much. I will be implementing the choose formula.
