MrDB4Excel
Board Regular
 Joined
 Jan 29, 2004
 Messages
 153
 Office Version

 2013
 Platform

 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.
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.
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) 