View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liketoknow Liketoknow is offline
external usenet poster
 
Posts: 7
Default worksheet formula problem

Hi..new to worksheet formula's and could use some guidance

i have created a worksheet with a formula in an entire row to calculate days
old.The formula looks at two cells and calculates the difference...thats the
easy part..works good =(c1-f14) etc

What i would like to know is
In the remaining cells down the row (containing formula) i get 38944 as a
value.even though there is no value in one of the date rows.Is there a way to
calculate only the populated rows and leave the others blank or with "0"

thanks in advance