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, ""))  
< / Html>

Comments

Popular posts from this blog

php - multilevel menu with multilevel array -

c# - TypeConverter in propertygrid only converts from string, not to -

jQuery UI: Datepicker month format -