# Same , True , False

#### Sunline

##### Well-known Member
Hello all ,

I am just needing a simple function that can tell me if col B is
greater than col A . True or false .

If the same then SAME .

Thanks .
Excel Workbook
ABC
1StakesStakes2Result Required
270007000SAME
3800012000TRUE
490007000FALSE
51000015000TRUE
6100000100000SAME
7200000250000TRUE
85000055000TRUE
92750025000FALSE
Sheet1

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Try

=IF(B2=A2,"SAME",IF(B2>A2,"TRUE","FALSE"))

In C2,
=IF(A2=B2,"SAME",B2>A2)

Thanks VoG , also mfexcel .
Thank you .

Replies
2
Views
50
Replies
3
Views
277
Replies
1
Views
413
Replies
3
Views
146
Replies
10
Views
223

1,203,453
Messages
6,055,530
Members
444,794
Latest member
HSAL

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back