Leigh Digons
Member
In Tab 2016 Actual, in columns BU, CK and so on, I am getting an inconsistent formula error. I did not get an inconsistent formula error before adding the following to the formula:
+IF($AR5="",0,(IF(OR($K5>BM$2,$K5=""),(((MAX(0,MIN(EOMONTH(BY$2,0)+1,$AS5)-MAX(BY$2,$AR5))))))))+IF($AT5="",0,(IF(OR($K5>BM$2,$K5=""),(((MAX(0,MIN(EOMONTH(BY$2,0)+1,$AU5)-MAX(BY$2,$AT5))))))))+IF($AV5="",0,(IF(OR($K5>BM$2,$K5=""),(((MAX(0,MIN(EOMONTH(BY$2,0)+1,$AW5)-MAX(BY$2,$AV5))))))))
January and December should have slightly different formulas than Feb-November, because they are looking up prior year and next year dates which are in different columns than Feb-November dates. But before I add the above to the formula, it worked just fine, no inconsistent formula error.
+IF($AR5="",0,(IF(OR($K5>BM$2,$K5=""),(((MAX(0,MIN(EOMONTH(BY$2,0)+1,$AS5)-MAX(BY$2,$AR5))))))))+IF($AT5="",0,(IF(OR($K5>BM$2,$K5=""),(((MAX(0,MIN(EOMONTH(BY$2,0)+1,$AU5)-MAX(BY$2,$AT5))))))))+IF($AV5="",0,(IF(OR($K5>BM$2,$K5=""),(((MAX(0,MIN(EOMONTH(BY$2,0)+1,$AW5)-MAX(BY$2,$AV5))))))))
January and December should have slightly different formulas than Feb-November, because they are looking up prior year and next year dates which are in different columns than Feb-November dates. But before I add the above to the formula, it worked just fine, no inconsistent formula error.