Thread: [Solved] True/False formula
View Single Post
 
Old 01-18-2020, 08:50 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
in B3:
=IF(A2=A3,B2,NOT(B2))
seed B2 with TRUE or FALSE


Note that in your file, cells A9 and A10 are different.
Reply With Quote