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. A...
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?
- Got it... Thanks alot. Problem Solved!
