Hi
I want to calculate how much i have saved from my bill budget for the month ($2250 for a 5 week month, and $1800 for a 4 week month).
I have 5 columns for each week of the month with a formula at the bottom that tallys how much i have spent of my $450 weekly budget (A12-Q12).
In the purple cell (on the image attached) I want a formula that can factor in whether it is a 5 week or a 4 week month. So if week 5 column has a $0 figure in the tally (Q12), then it must be a 4 week month so minus what I have saved from $1800, not $2250. Alternatively, if the week 5 column has a figure of >$0, then it is a 5 week month so minus what i have saved from $2250.
Put simply,
IF Q12 = >$0
U12 = (A12 + E12 + I12 + M12 + Q12) - 2250
BUT IF Q12 = $0
U12 = (A12 + E12 + I12 + M12) - 1800
How do i get this into one formula?
Thanks
Anita
Bookmarks