eliminating #value when computing average
 

An example:
if dividing cells A1/B1 in C1 and either A1 or B1 is blank i get a #value
display in C1..
What is a good way to eliminate this? - or better yet to indicate A1 is
blank, or B1 is blank?

eliminating #value when computing average
 

=IF(ISERROR(A1/B1),"".A1/B1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Junior" wrote in message
...
An example:
if dividing cells A1/B1 in C1 and either A1 or B1 is blank i get a #value
display in C1..
What is a good way to eliminate this? - or better yet to indicate A1 is
blank, or B1 is blank?

eliminating #value when computing average
 

Bob thanks
"Bob Phillips" wrote in message
...
=IF(ISERROR(A1/B1),"".A1/B1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Junior" wrote in message
...
An example:
if dividing cells A1/B1 in C1 and either A1 or B1 is blank i get a
#value
display in C1..
What is a good way to eliminate this? - or better yet to indicate A1 is
blank, or B1 is blank?