eliminating #value when computing average

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

 

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

 

[Junior]

Bob thanks

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