Forum Discussion
Solved
Return Blank Value instead of Zero
I am trying to do a min and average for different columns of data. The formula I used returned a zero value for blank cells. I need them to be blank. Tried a few formulas, but was unsuccessful. Appreciate if someone could help.
7 Replies
As a comment, formulas in Excel can't return blank as a value. You may return zero and not show it using custom format or Excel settings; or you may return empty string. But not blank.
- Thanks for the reply. I saw the query, can I verify that you change the type to whole number?
- Sorry, I don't see the formula. Btw, I am using excel 2016.
