• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula not to show zero

D

drewszone32

Member
=MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY()))

I have the following formula in F2 cell. I would like to have this cell to show blank instead of zero.
 
drewszone32 said:
=MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY()))

I have the following formula in F2 cell. I would like to have this cell to show blank instead of zero.
Click to expand...

=IF(MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY()))=0,"",MIN(SUMIFS(H2:NH2,$H$1:$NH$1,">="&EDATE(TODAY(),-181),H2:NH2,"<="&TODAY())))
 
You must log in or register to reply here.
Back
Top