Leaving a Cell Blank if one value of the formula is blank
Closed
peckman
Posts
1
Registration date
Saturday 10 November 2012
Status
Member
Last seen
10 November 2012
-
10 Nov 2012 à 00:27
MelyElly Posts 3 Registration date Wednesday 21 November 2012 Status Member Last seen 23 November 2012 - 21 Nov 2012 à 20:07
MelyElly Posts 3 Registration date Wednesday 21 November 2012 Status Member Last seen 23 November 2012 - 21 Nov 2012 à 20:07
Related:
- Leaving a Cell Blank if one value of the formula is blank
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Based on the values of cell b77 ✓ - Excel Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
- Laptop blank screen asus - Laptop Forum
- Spreadsheet formula - Guide
2 responses
aquarelle
Posts
7181
Registration date
Saturday 7 April 2007
Status
Moderator
Last seen
14 February 2026
491
10 Nov 2012 à 12:05
10 Nov 2012 à 12:05
Hi,
Try this formula :
= IF(A1="",""),TODAY()-A1)
Regards
Try this formula :
= IF(A1="",""),TODAY()-A1)
Regards
MelyElly
Posts
3
Registration date
Wednesday 21 November 2012
Status
Member
Last seen
23 November 2012
21 Nov 2012 à 20:07
21 Nov 2012 à 20:07
This is the exact function you need:
=IF(A1="","",(TODAY())-A1)
It should work perfectly!
=IF(A1="","",(TODAY())-A1)
It should work perfectly!