View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cls cls is offline
external usenet poster
 
Posts: 3
Default if zero, then return blank/empty

Column F is sometimes empty. Sometimes does contain a value. Column H
contains the formula = F1 / 900. F2 / 900. F3 / 900. ... Currently, if a
row in column H refers to a blank row in column F, I get a return value of
zero. Any way to write the formula so that if row F is empty/blank, then I
get a blank/null return value?? or if it is zero, do not show??