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))

You could have something like:

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

Hope this helps.

Pete

On Oct 10, 9:39 am, Jontie wrote:
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))

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

Regards,
Stefi

€žJontie€� ezt Ã*rta:

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))

On Oct 10, 6:00 am, Stefi wrote:
=IF(COUNT(A6:A12)=0,"",AVERAGE(A6:A12))

Regards,
Stefi

,,Jontie" ezt írta:



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))- Hide quoted text -

- 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

On Wed, 10 Oct 2007 01:39:56 -0700, Jontie wrote:

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

On Wed, 10 Oct 2007 01:39:56 -0700, Jontie wrote:

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

On Oct 10, 1:49 pm, Ron Rosenfeld wrote:
On Wed, 10 Oct 2007 01:39:56 -0700, Jontie wrote:
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

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

On Thu, 11 Oct 2007 15:55:23 -0700, Jontie wrote:

On Oct 10, 1:49 pm, Ron Rosenfeld wrote:
On Wed, 10 Oct 2007 01:39:56 -0700, Jontie wrote:
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

.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
a

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


--ron

On Oct 11, 8:16 pm, Ron Rosenfeld wrote:
On Thu, 11 Oct 2007 15:55:23 -0700, Jontie wrote:
On Oct 10, 1:49 pm, Ron Rosenfeld wrote:
On Wed, 10 Oct 2007 01:39:56 -0700, Jontie wrote:
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

.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
a

=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
"

On Thu, 11 Oct 2007 19:23:03 -0700, Jontie wrote:

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

On Oct 11, 10:29 pm, Ron Rosenfeld wrote:
On Thu, 11 Oct 2007 19:23:03 -0700, Jontie wrote:
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





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]