MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 348
- 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) |