Exact

AnnThompson

I just want to compare 2 cells (=exact in excel) if they are exact then true, if not then false, why am I struggling

Kerry St. Thomas

=IF(Column1@row=Column2@row,1,0) applied to a column of type Checkbox will do this comparison. Sometimes, confounding issues will arise (e.g. if the columns are of different types). If you're comparing numbers, you'll definitely want to review your output for accuracy - there's a possibility you are VIEWING a rounded number but there's an underlying decimal, or that you're viewing what LOOKS like a number but is reading as text. (You can fix these by using ROUND and/or VALUE formulas to wrap Column1@row and Column2@row to standardize format.)

Good luck!

Kerry St. Thomas

=IF(Column1@row=Column2@row,1,0) applied to a column of type Checkbox will do this comparison. Sometimes, confounding issues will arise (e.g. if the columns are of different types). If you're comparing numbers, you'll definitely want to review your output for accuracy - there's a possibility you are VIEWING a rounded number but there's an underlying decimal, or that you're viewing what LOOKS like a number but is reading as text. (You can fix these by using ROUND and/or VALUE formulas to wrap Column1@row and Column2@row to standardize format.)

Good luck!

AnnThompson

This worked perfectly! Thank you! so much!