True/False formula

		Microsoft Office Forums > Microsoft Excel > Excel
True/False formula

FAQ

Thread Tools

Display Modes

01-17-2020, 09:38 AM

wheddingsjr wheddingsjr is offline

Windows 7 64bit True/False formula

Office 2016

Advanced Beginner

Join Date: Mar 2017

Posts: 76

True/False formula

Hi all

I used to have a formula that I would use to determine if a number in a column was the same as the one above it and each time the number changed the cell with the formula in it would populate with TRUE or FALSE (Obviously the first row in the formula column had to be manually written in). But I started a new job and left my list of formulas behind. I am attaching an example as a reference.

Thanks

Attached Files

Book1.xlsx (10.7 KB, 12 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
True/False Error	DonBerg68	Excel	2	08-30-2019 08:51 PM
Converting a 1 or 0 into TRUE or FALSE?	ayupchap	Mail Merge	1	04-25-2017 02:45 PM
Can you do True or False equations in Excel?	WisCowboy	Excel	1	02-05-2016 04:53 PM
Task Indicator - All predecessors complete true/false, y/n	jdove78	Project	2	10-10-2012 05:53 PM
Mail Merge Function not Noticing 'True' vs. 'False' Statement	danellekent	Mail Merge	1	04-27-2012 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:14 AM.