Need Cells in Column B to be Blank

MrDB4Excel

Active Member
Joined
Jan 29, 2004
Messages
334
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)
 
Glad we could help & thanks for the feedback.
 
Upvote 0

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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,"")
 
Upvote 0

Forum statistics

Threads
1,214,919
Messages
6,122,260
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top