Mar 06 2023 07:07 AM
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….
(SEE ATTACHED) specifically “TAB TOTAL EXPENS
Mar 06 2023 07:20 AM
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
Mar 06 2023 12:26 PM