Same , True , False

[Sunline]

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
	A	B	C
1	Stakes	Stakes2	Result Required
2	7000	7000	SAME
3	8000	12000	TRUE
4	9000	7000	FALSE
5	10000	15000	TRUE
6	100000	100000	SAME
7	200000	250000	TRUE
8	50000	55000	TRUE
9	27500	25000	FALSE
Sheet1

 

[VoG]

Try

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

 

[mfexcel]

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

 

[Sunline]

Thanks VoG , also mfexcel .
Both great answers .
Thank you .