Hi, I have a budget template that has IF statements to exclude costs bases on the max allowed ($25,000) and the previous years' totals. I have 4 groups of these per year for 6 years and all the IF statements appear to be set up the same and work in all but one of the groups and I can't figure out why!
Basically my problem is when I get to the 4th year and I want the calculation to take into account the totals from the previous three as well as the 4th and whether or not we have exceeded $25,000.
As I said, I have 4 sections of these and all three other sections work but this one and I've already checked the cell formatting and it's exactly the same for all these.
=IF('Yrs 1-3'!L53+'Yrs 1-3'!Q53+'Yrs 1-3'!G53+'Yrs 4-6'!G53>25000,G53,IF(('Yrs 1-3'!G53+'Yrs 1-3'!L53+'Yrs 1-3'!Q53+'Yrs 4-6'!G53)<25000,0,(('Yrs 1-3'!G53+'Yrs 1-3'!L53+'Yrs 1-3'!Q53+'Yrs 4-6'!G53)-25000)))
=IF(('Yrs 1-3'!G53-'Yrs 1-3'!L53-'Yrs 1-3'!Q53-G53)<25000,G53,G53-G54)
This is the calculation directly above that works;
=IF('Yrs 1-3'!L48+'Yrs 1-3'!Q48+'Yrs 1-3'!G48+G48>25000,G48,IF(('Yrs 1-3'!G48+'Yrs 1-3'!L48+'Yrs 1-3'!Q48+'Yrs 4-6'!G48)<25000,0,(('Yrs 1-3'!G48+'Yrs 1-3'!L48+'Yrs 1-3'!Q48+'Yrs 4-6'!G48)-25000)))
=IF(('Yrs 1-3'!G48-'Yrs 1-3'!L48-'Yrs 1-3'!Q48-G48)<25000,G48,G48-G49)
Any help is GREATLY appreciated!
Basically my problem is when I get to the 4th year and I want the calculation to take into account the totals from the previous three as well as the 4th and whether or not we have exceeded $25,000.
As I said, I have 4 sections of these and all three other sections work but this one and I've already checked the cell formatting and it's exactly the same for all these.
=IF('Yrs 1-3'!L53+'Yrs 1-3'!Q53+'Yrs 1-3'!G53+'Yrs 4-6'!G53>25000,G53,IF(('Yrs 1-3'!G53+'Yrs 1-3'!L53+'Yrs 1-3'!Q53+'Yrs 4-6'!G53)<25000,0,(('Yrs 1-3'!G53+'Yrs 1-3'!L53+'Yrs 1-3'!Q53+'Yrs 4-6'!G53)-25000)))
=IF(('Yrs 1-3'!G53-'Yrs 1-3'!L53-'Yrs 1-3'!Q53-G53)<25000,G53,G53-G54)
This is the calculation directly above that works;
=IF('Yrs 1-3'!L48+'Yrs 1-3'!Q48+'Yrs 1-3'!G48+G48>25000,G48,IF(('Yrs 1-3'!G48+'Yrs 1-3'!L48+'Yrs 1-3'!Q48+'Yrs 4-6'!G48)<25000,0,(('Yrs 1-3'!G48+'Yrs 1-3'!L48+'Yrs 1-3'!Q48+'Yrs 4-6'!G48)-25000)))
=IF(('Yrs 1-3'!G48-'Yrs 1-3'!L48-'Yrs 1-3'!Q48-G48)<25000,G48,G48-G49)
Any help is GREATLY appreciated!