Forum Discussion
Need help with formula
I am trying to create a IF statement that will work for the following situation:
I currently have the sheet set up to calculate dates based upon previous data input. Column G will calculate a ...
=IF(A7="","",IF(OR(ISBLANK(H7)), TEXT(A7+45,"dd-mmm-yy"),"see Due Date after resubmission"))
Add a if formula to wrap your column G's formula is a simple why way to fix it.