IF Function

[MattA2160]

Want to write True,False for monthly > 50000.

Have tried  =IF(E3>50000,TRUE,FALSE)

=IF(E3>"50000",TRUE,FALSE) 

=IF(E3>"50000","TRUE,FALSE")

Always give the answer 0.

[#2]

@MattA2160 

=IF(E3>50000,"TRUE","FALSE")

This works in my sheet. 

[#3]

@MattA2160 

As variant

=E3>50000