Need Cells in Column B to be Blank

[MrDB4Excel]

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
	A	B	C	D	E
1	Received Date Gleaned From Get Outlook Metadata.xlsm	Received Date Formulas	Received Time Formulas	Received Time In Formula	Received Time: Pasted Values From Column "D"
2	10/18/2020 09:03:21	Sun 18/Oct/2020	09:03:21	09:03	09:03
3	10/19/2020 05:20:18	Mon 19/Oct/2020	05:20:18	05:20	05:20
4	10/19/2020 20:06:59	Mon 19/Oct/2020	20:06:59	20:07	20:07
5	10/20/2020 10:53:45	Tue 20/Oct/2020	10:53:45	10:54	10:54
6	10/20/2020 23:35:48	Tue 20/Oct/2020	23:35:48	23:36	23:36
7	10/21/2020 06:23:49	Wed 21/Oct/2020	06:23:49	06:24	06:24
8	10/21/2020 22:34:10	Wed 21/Oct/2020	22:34:10	22:34	22:34
9	10/22/2020 00:45:07	Thu 22/Oct/2020	00:45:07	00:45	00:45
10	10/19/2020 21:18:08	Mon 19/Oct/2020	21:18:08	21:18	21:18
11	10/21/2020 02:14:35	Wed 21/Oct/2020	02:14:35	02:15	02:15
12	10/21/2020 08:16:27	Wed 21/Oct/2020	08:16:27	08:16	08:16
13	10/22/2020 01:34:03	Thu 22/Oct/2020	01:34:03	01:34	01:34
14	10/22/2020 01:34:03	Sat 00/Jan/1900	01:34:03	01:34
15		#VALUE!	00:00:00	00:00
16		#VALUE!	00:00:00	00:00
17		#VALUE!	00:00:00	00:00
18		#VALUE!	00:00:00	00:00
19		#VALUE!	00:00:00	00:00
20		#VALUE!	00:00:00	00:00
21		#VALUE!	00:00:00	00:00
22		#VALUE!	00:00:00	00:00
23		Sat 00/Jan/1900	00:00:00	00:00
24		Sat 00/Jan/1900	00:00:00	00:00
25		Sat 00/Jan/1900	00:00:00	00:00
Outlook Results

Cell Formulas
Range	Formula
B23:B25,B2:B13	B2	=INT(A2)
C2:C25	C2	=A2 - INT(A2)
D2:D25	D2	=MROUND(C2,"0:1")
B14:B22	B14	=IF(A14="","")*INT(A14)

 

[sandy666]

maybe IFERROR(your_formula, "") with appropriate reference from the beginning

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

 

[MrDB4Excel]

It comes back with a generic date, as in,

It is supposed to return in Column B the date shown in column A, as in,

which comes from row 5.

 

[sandy666]

try in B2 =IF(A2="",""),INT(A2) and drag down

 

[sandy666]

or use Power Query

Received Date Gleaned From Get Outlook Metadata.xlsm	Date	Time
18/10/2020 09:03	18/10/2020	09:03:21
19/10/2020 05:20	19/10/2020	05:20:18
19/10/2020 20:06	19/10/2020	20:06:59
20/10/2020 10:53	20/10/2020	10:53:45
20/10/2020 23:35	20/10/2020	23:35:48
21/10/2020 06:23	21/10/2020	06:23:49
21/10/2020 22:34	21/10/2020	22:34:10
22/10/2020 00:45	22/10/2020	00:45:07
19/10/2020 21:18	19/10/2020	21:18:08
21/10/2020 02:14	21/10/2020	02:14:35
21/10/2020 08:16	21/10/2020	08:16:27
22/10/2020 01:34	22/10/2020	01:34:03
22/10/2020 01:34	22/10/2020	01:34:03

 

[MrDB4Excel]

does not work

 

[Fluff]

How about

=IF(A14="","",INT(A14))

 

[sandy666]

what is your system separator?
maybe it will work =IF(A2="",""); INT(A2)

 

[MrDB4Excel]

or use Power Query

Received Date Gleaned From Get Outlook Metadata.xlsm	Date	Time
18/10/2020 09:03	18/10/2020	09:03:21
19/10/2020 05:20	19/10/2020	05:20:18
19/10/2020 20:06	19/10/2020	20:06:59
20/10/2020 10:53	20/10/2020	10:53:45
20/10/2020 23:35	20/10/2020	23:35:48
21/10/2020 06:23	21/10/2020	06:23:49
21/10/2020 22:34	21/10/2020	22:34:10
22/10/2020 00:45	22/10/2020	00:45:07
19/10/2020 21:18	19/10/2020	21:18:08
21/10/2020 02:14	21/10/2020	02:14:35
21/10/2020 08:16	21/10/2020	08:16:27
22/10/2020 01:34	22/10/2020	01:34:03
22/10/2020 01:34	22/10/2020	01: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]

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