I have attached a small sheet. how to calculate the average with out showing #div/0! in the sheet and also on the YTD cell is not calculating the results.
I have attached a small sheet. how to calculate the average with out showing #div/0! in the sheet and also on the YTD cell is not calculating the results.
Hi ancherilvm,
Could you please change your thread title to something other than "formula help" as it doesn't describe the problem. How about something like "How to use the IfError() Function".
Then we can help with an answer. (or you could look up IfError )
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I'm not even going to look at the sheet. One function you can use is IFERROR()
=MyCurrentFormula
becomes:
=IFERROR(MyCurrentFormula, 0)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks