Need Cells in Column B to be Blank

MrDB4Excel

Board Regular
Joined
Jan 29, 2004
Messages
153
Office Version
  1. 2013
Platform
  1. Windows
I need cells in Column B to be blank if the corresponding row cell in column A is blank.
As you can see by the XL2BB attached range you will note there are 2 distinct formulas: =INT(A2) and =IF(A14="","")*INT(A14).
The next row down is =IF(A15="","")*INT(A15) but because column A, Row 15 is blank it returns #VALUE.
I want to incorporate =INT(A14) with IF(A14="",""). Excel sets the multiplication operator between these two as a fix, but it does not work.
XL2BB Testing.xlsx
ABCDE
1Received Date Gleaned From Get Outlook Metadata.xlsmReceived Date FormulasReceived Time FormulasReceived Time In FormulaReceived Time: Pasted Values From Column "D"
210/18/2020 09:03:21Sun 18/Oct/202009:03:2109:0309:03
310/19/2020 05:20:18Mon 19/Oct/202005:20:1805:2005:20
410/19/2020 20:06:59Mon 19/Oct/202020:06:5920:0720:07
510/20/2020 10:53:45Tue 20/Oct/202010:53:4510:5410:54
610/20/2020 23:35:48Tue 20/Oct/202023:35:4823:3623:36
710/21/2020 06:23:49Wed 21/Oct/202006:23:4906:2406:24
810/21/2020 22:34:10Wed 21/Oct/202022:34:1022:3422:34
910/22/2020 00:45:07Thu 22/Oct/202000:45:0700:4500:45
1010/19/2020 21:18:08Mon 19/Oct/202021:18:0821:1821:18
1110/21/2020 02:14:35Wed 21/Oct/202002:14:3502:1502:15
1210/21/2020 08:16:27Wed 21/Oct/202008:16:2708:1608:16
1310/22/2020 01:34:03Thu 22/Oct/202001:34:0301:3401:34
1410/22/2020 01:34:03Sat 00/Jan/190001:34:0301:34
15#VALUE!00:00:0000:00
16#VALUE!00:00:0000:00
17#VALUE!00:00:0000:00
18#VALUE!00:00:0000:00
19#VALUE!00:00:0000:00
20#VALUE!00:00:0000:00
21#VALUE!00:00:0000:00
22#VALUE!00:00:0000:00
23Sat 00/Jan/190000:00:0000:00
24Sat 00/Jan/190000:00:0000:00
25Sat 00/Jan/190000:00:0000:00
Outlook Results
Cell Formulas
RangeFormula
B23:B25,B2:B13B2=INT(A2)
C2:C25C2=A2 - INT(A2)
D2:D25D2=MROUND(C2,"0:1")
B14:B22B14=IF(A14="","")*INT(A14)
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,126
maybe IFERROR(your_formula, "") with appropriate reference from the beginning

your formula: =IF(A15="","")*INT(A15)
 

MrDB4Excel

Board Regular
Joined
Jan 29, 2004
Messages
153
Office Version
  1. 2013
Platform
  1. Windows
It comes back with a generic date, as in,
1603373184739.png

It is supposed to return in Column B the date shown in column A, as in,
1603373206438.png
which comes from row 5.
 
Last edited:

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,126

ADVERTISEMENT

or use Power Query
Received Date Gleaned From Get Outlook Metadata.xlsmDateTime
18/10/2020 09:0318/10/202009:03:21
19/10/2020 05:2019/10/202005:20:18
19/10/2020 20:0619/10/202020:06:59
20/10/2020 10:5320/10/202010:53:45
20/10/2020 23:3520/10/202023:35:48
21/10/2020 06:2321/10/202006:23:49
21/10/2020 22:3421/10/202022:34:10
22/10/2020 00:4522/10/202000:45:07
19/10/2020 21:1819/10/202021:18:08
21/10/2020 02:1421/10/202002:14:35
21/10/2020 08:1621/10/202008:16:27
22/10/2020 01:3422/10/202001:34:03
22/10/2020 01:3422/10/202001:34:03
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,423
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

How about
Excel Formula:
=IF(A14="","",INT(A14))
 

MrDB4Excel

Board Regular
Joined
Jan 29, 2004
Messages
153
Office Version
  1. 2013
Platform
  1. Windows
or use Power Query
Received Date Gleaned From Get Outlook Metadata.xlsmDateTime
18/10/2020 09:0318/10/202009:03:21
19/10/2020 05:2019/10/202005:20:18
19/10/2020 20:0619/10/202020:06:59
20/10/2020 10:5320/10/202010:53:45
20/10/2020 23:3520/10/202023:35:48
21/10/2020 06:2321/10/202006:23:49
21/10/2020 22:3421/10/202022:34:10
22/10/2020 00:4522/10/202000:45:07
19/10/2020 21:1819/10/202021:18:08
21/10/2020 02:1421/10/202002:14:35
21/10/2020 08:1621/10/202008:16:27
22/10/2020 01:3422/10/202001:34:03
22/10/2020 01:3422/10/202001:34:03
This is supposed to be a very simple operation to glean data from my outlook and paste it elsewhere in this file after the formulas do their thing with the data.
So I think I will either deal with this the old fashion way but I am not real keen on doing a Power Query.

Adding the semicolon did not work.
 

MrDB4Excel

Board Regular
Joined
Jan 29, 2004
Messages
153
Office Version
  1. 2013
Platform
  1. Windows
This is supposed to be a very simple operation to glean data from my outlook and paste it elsewhere in this file after the formulas do their thing with the data.
So I think I will either deal with this the old fashion way but I am not real keen on doing a Power Query.

Adding the semicolon did not work.
Now this is working: =IF(A15="","",INT(A15))
Thank you so much
 

Watch MrExcel Video

Forum statistics

Threads
1,114,492
Messages
5,548,362
Members
410,828
Latest member
A9Bosv3
Top