Leaving a Cell Blank if one value of the formula is blank
Closed
peckman
Posts
1
Registration date
Saturday November 10, 2012
Status
Member
Last seen
November 10, 2012
-
Nov 10, 2012 at 12:27 AM
MelyElly Posts 3 Registration date Wednesday November 21, 2012 Status Member Last seen November 23, 2012 - Nov 21, 2012 at 08:07 PM
MelyElly Posts 3 Registration date Wednesday November 21, 2012 Status Member Last seen November 23, 2012 - Nov 21, 2012 at 08:07 PM
Related:
- Leaving a Cell Blank if one value of the formula is blank
- Facebook page blank ✓ - Facebook Forum
- Different dates of "end to end encryption message" on blank chat? - Excel Forum
- Based on the values of cell b77 ✓ - Excel Forum
- Excel cell color formula - Guide
- Laptop screen blank ✓ - Laptop Forum
2 responses
MelyElly
Posts
3
Registration date
Wednesday November 21, 2012
Status
Member
Last seen
November 23, 2012
Nov 21, 2012 at 08:07 PM
Nov 21, 2012 at 08:07 PM
This is the exact function you need:
=IF(A1="","",(TODAY())-A1)
It should work perfectly!
=IF(A1="","",(TODAY())-A1)
It should work perfectly!