Thread: Help Buffs!
View Single Post
  #6  
Old 9th March 2014, 04:01 PM
Dennis G Dennis G is offline
Member
  
Join Date: Mar 2006
Posts: 112
Default
Party,
another one to try...

In B2 =IF(A2<>"",IF(A2=1,0,IF(A2=0,1,"")),"")

Covers 1s, 0s and blank cells.
Reply With Quote