Return Blank Value instead of Zero

[choongko]

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. 

[#2 · Accepted solution]

@choongko 

A PQ solution in the attached file.

[#3]

Sorry, I don't see the formula. Btw, I am using excel 2016.

[#4]

@choongko 

This is a Power query (PQ) solution. You have to go to the query editor and see the query.

[#5]

@choongko 

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.

[#6]

Thanks for the reply. I saw the query, can I verify that you change the type to whole number?

[#7]

@choongko 

As you can see in the query all four values are data type decimal.

[#8]

Got it... Thanks alot. Problem Solved!