Forum Discussion
IF Function spilling
I've created a complex IF Function with nesting in order to give me an accurate estimation of my monthly and yearly income/ expenses based on previous fortnightly bookkeeping. I've gotten up to one I...
Riny_van_Eekelen I've re-loaded this for you
OliverHoldway Got it now! Its the very last part of the formula:
+((I30:I33)/14)
Here, you add a range of cells divided by 14. Excel then spills the result for each of the cells in an array of 4 cells. I guess you want to use +SUM(I30:I33)/14 here.