Thread: B1 = B2, if B2 is blank, can B1 also be blank, but not zero?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default B1 = B2, if B2 is blank, can B1 also be blank, but not zero?
In B1 enter =IF(B2="","",B2)


Gord Dibben MS Excel MVP

On Fri, 2 Nov 2007 23:59:00 -0700, JMS wrote:

Thank you very much!

Reply With QuoteReply With Quote