Hi,
I have attached a file here.
In this file i want the red coloured cells not to show zero (0) or anything unless anything else is entered in the cells above.
In other words I want to hide the zero if nothing is entered above.
Thank you..
Hi,
I have attached a file here.
In this file i want the red coloured cells not to show zero (0) or anything unless anything else is entered in the cells above.
In other words I want to hide the zero if nothing is entered above.
Thank you..
welcome to the forum. try this in D5:
=IFERROR(1/(1/SUM(D2:D4)),"")
this in D6:
=IFERROR(D5/3,"")
copy across
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi and welcome to the forum
D5=IF(SUM(D2:D4)=0,"",SUM(D2:D4))
D6=IF(D5="","",D5/3)
Both copied across
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
=IF(COUNTA(C2:C4)=0,"",SUM(C2:C4)) enter in Cell "C5"
=IF(COUNTA(C2:C4)=0,"",C5/COUNTA(C2:C4)) enter in Cell "C6"
and Copy towards right
Thank you all,
All the three types of fomulas you guyz gave me works great.
Thank you very much you guyz have been very helpful...
This forum is great..
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks