excel - Nested If Statements Returning zero if nothing entered in cell -
The formula listed below. I would like to go back to zero if nothing is recorded in the cell. How do i do this
= IF (E6> 0, F6 / E6, "")
= IF (ISBLANK (E6), 0, IF (E6 & gt; 0, F6 / E6, ""))
Comments
Post a Comment