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...
OliverHoldway And how does that formula look like?
- 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.
OliverHoldway Testing your formula but it seems overly complicated. Am stuck on one bit. What exactly do you have in C3. You mention that it contains "how many days are left in the month". What value/formula is in there now?
