View Single Post
  #3  
Old 27th September 2016, 06:24 PM
walkermac walkermac is offline
Member
 
Join Date: Nov 2013
Posts: 603
Default

In cell AA2:

=if(s2=0,1,0)

(presuming s2 can only contain the values 0 or 1)
Reply With Quote