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)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,425
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,126
Note
Syntax
Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false.
IF(logical_test, value_if_true, [value_if_false])
For example:
  • =IF(A2>B2,"Over Budget","OK")
  • =IF(A2=B2,B4-A4,"")
 

Watch MrExcel Video

Forum statistics

Threads
1,114,495
Messages
5,548,383
Members
410,830
Latest member
Tubtechbob
Top