need to hide "div/0!"

[Jontie]

I have this formula an if there is no data them i get div/0 how to fix
it so if no data then blank
=AVERAGE(IF(N6:N100=0,"",N6:N100))

 

[Pete_UK]

You could have something like:

=IF(COUNT(N6:N100)=0,"",your_formula)

Hope this helps.

Pete

 

[Guest]

=IF(COUNT(A6:A12)=0,"",AVERAGE(A6:A12))

Regards,
Stefi

„Jontie†ezt írta:

 

[Jontie]

=IF(COUNT(A6:A12)=0,"",AVERAGE(A6:A12))

Regards,
Stefi

,,Jontie" ezt írta:




- Show quoted text -

Stefi thanks for it but when i put this formula in the cell it gave me
number in decimal place where real it should have given me 30 but the
answer was way too off the scale

 

[Ron Rosenfeld]

I have this formula an if there is no data them i get div/0 how to fix
it so if no data then blank
=AVERAGE(IF(N6:N100=0,"",N6:N100))

Try this instead:

=IF(SUM(N6:N100)=0,"",AVERAGE(N6:N100))

entered as a normal formula
--ron

 

[Ron Rosenfeld]

I have this formula an if there is no data them i get div/0 how to fix
it so if no data then blank
=AVERAGE(IF(N6:N100=0,"",N6:N100))

Sorry, that should have been:

=IF(COUNT(N6:N100)=0,"",AVERAGE(N6:N100))


--ron

 

[Jontie]

Sorry, that should have been:

=IF(COUNT(N6:N100)=0,"",AVERAGE(N6:N100))

--ron

..3368 is the answer i m getting after using the above formula where as
it should be 32

 

[Ron Rosenfeld]

.3368 is the answer i m getting after using the above formula where as
it should be 32

Then there is a problem with your interpretation of your data.

Place the following formulas on your worksheet and tell me what the results
are:

=AVERAGE(N6:N100)
=COUNT(N6:N100)
=SUM(N6:N100)


--ron

 

[Jontie]

Then there is a problem with your interpretation of your data.

Place the following formulas on your worksheet and tell me what the results
are:

=AVERAGE(N6:N100)
=COUNT(N6:N100)
=SUM(N6:N100)

--ron

thank you for your help and that was a mistake on my part. sorry you
were right.

thanks for everyone who answered my questions and my template is now
processing and soon will be avaliable to download on the "microsoft
office online" under excel templates . with a name of
"Short Term Stock Investments
"

 

[Ron Rosenfeld]

thank you for your help and that was a mistake on my part. sorry you
were right.

thanks for everyone who answered my questions and my template is now
processing and soon will be avaliable to download on the "microsoft
office online" under excel templates . with a name of
"Short Term Stock Investments
"

Glad you got it worked out. Thanks for the feedback.
--ron

 

[Jontie]

Glad you got it worked out. Thanks for the feedback.
--ron

thank you all for you answers my template is up on "Microsoft Online"
webpagenow here is the handy link in case you guys want to see your
contribution to it under search term of "Swing Trading Calculator" and
link is [http://office.microsoft.com/en-us/templates/
TC300009021033.aspx?pid=CT101444811033]