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