Required value as per the scanned data
Closed
mebaznm14
TrowaD
- Posts
- 1
- Registration date
- Sunday March 25, 2018
- Status
- Member
- Last seen
- March 25, 2018
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Required value as per the scanned data
- The required data was not placed into memory windows 10 - Forum - Windows 10
- The nvidia smart scan requires the latest version of java - Guide
- Accounts data requires automatic analysis ✓ - Forum - Excel
- Transfer data from one excel worksheet to another automatically - Guide
- Digital data transmission - Articles
1 reply
TrowaD
Mar 27, 2018 at 11:23 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Mar 27, 2018 at 11:23 AM
Hi Mebaznm14,
Give the following formula a try for column K:
=IF(A2="",0,1)
If A2 is empty then result is 0, otherwise 1.
Best regards,
Trowa
Give the following formula a try for column K:
=IF(A2="",0,1)
If A2 is empty then result is 0, otherwise 1.
Best regards,
Trowa