eliminating #value when computing average

J

Junior

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?
 
B

Bob Phillips

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

Junior

Bob thanks
Bob Phillips said:
=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)
Click to expand...
 
Top