CarolBell44
New Member
- Joined
- Nov 23, 2016
- Messages
- 9
I am using this formula in cell P13 =IF(ISBLANK(N13),"",N13-F13) and it works when there is data in cell N13. The problem I have that cell N13 has this formula in =IF(M13<>"",IF(N13="",NOW(),N13), "") therefore I get #VALUE in cell P13 until a date is entered in cell N13. I want this to show blank or even a zero, or some text.
Is this at all possible?
Hope someone can help me please
Is this at all possible?
Hope someone can help me please