Thread: eliminating #value when computing average
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Junior[_2_] Junior[_2_] is offline
external usenet poster
  
Posts: 11
Default 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?


Reply With QuoteReply With Quote