LinkBack URL
About LinkBacks
Dear all,
How to modify the sum formula SUM(A5:E5)/5
if no value in the range A5:E5 then it is showing default results as 0 (zero)
but i want to get the results Blank as i did not put any value in the c (i mean no input value no output value)
Dear all,
How to modify the sum formula SUM(A5:E5)/5
if no value in the range A5:E5 then it is showing default results as 0 (zero)
but i want to get the results Blank as i did not put any value in the c (i mean no input value no output value)
=if(count(a5:e5)=0,"",sum(a5:e5)/5)
Life's a spreadsheet, Excel!
Say thanks, Click *
Hello nur2544,
It depends on what you really want.
Try:Also see the "Please consider" note at the bottom of this post.
=IF(AND(A5,B5,C5,D5,E5=""),"",SUM(A5:E5)/5)
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Unless you want the cell to truly be blank and not contain a formula in it if there is no result. In that case, I think you'd need to use VBA.=IF(SUM(A5:E5)/5=0,"",SUM(A5:E5)/5)
Edit: Winon's formula is a better way to go if you're using any negative values and there's a chance that the sum could equal 0 even with values entered.
Thanks goes to below listed excel expert as all logic are excellent. I appreciate...
Ace_XL
JSallen
Winon
Hello nur2544,
You are welcome.
Glad we could help.
Thank you for thr Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks