Thread: Cell to return null instead of 0
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Cell to return null instead of 0
hopefully just a typo
=If(sheet1!B138=0."",sheet1!b138)
you have a period instead of a comma
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


Reply With QuoteReply With Quote