When I copy this code to the cells below it, IF the reference Cell is empty it puts dates in all the cells (exp. 1/1/1900) how can I safely Convert these formulas into the IF CellBlank Fomula?
HERE IS THE FILE : Accruals Calculations.xlsx
When I copy this code to the cells below it, IF the reference Cell is empty it puts dates in all the cells (exp. 1/1/1900) how can I safely Convert these formulas into the IF CellBlank Fomula?
HERE IS THE FILE : Accruals Calculations.xlsx
Perhaps=IF(B7="","",B7+14-MOD(B7-$A$3,14))
How about this one? =C9+(14*13)
I would guess use the exact same method Pepe provided.
=IF(C9="","",C9+(14*13))
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks