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
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
2 responses
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Nov 10, 2012 at 12:05 PM
Nov 10, 2012 at 12:05 PM
Hi,
Try this formula :
= IF(A1="",""),TODAY()-A1)
Regards
Try this formula :
= IF(A1="",""),TODAY()-A1)
Regards
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!