Simple IF Statement not working :-(

[snoozee]

The data in my spreadsheet is being pulled from an SQL database and the columns are all formatted as 'General'.

The weird part about this is some of my IF statements are working and others aren't, this one works =IF([@Amount]>5000,"Yes","No"). The amount column is in a General format and so is the column that I'm putting the formula into.

I then have this formula =IF([@[Note_50]]>5000,"Yes","No") which isn't working (extract below) and once again both columns are formatted to General.

Any help would be greatly appreciated as I can't work out why it would be doing this

Note_50	Over 5k
100.00	Yes
	No
6000.00	Yes
150.00	Yes

 

[StephenCrump]

Your "numbers" in Note_50 look like text values - left justified.

="100.00">5000 will return TRUE, for example.

 

[snoozee]

Your "numbers" in Note_50 look like text values - left justified.

="100.00">5000 will return TRUE, for example.

That was me typing them into the table so not an actual extract of my spreadsheet

 

[StephenCrump]

That was me typing them into the table so not an actual extract of my spreadsheet

OK ... but my comment still stands. I can replicate your incorrect results if the values in Note_50 are text, rather than numbers.

	A	B	C	D
1
2		Note_50	Over 5K
3		100.00	TRUE
4			FALSE
5		6000.00	TRUE
6		150.00	TRUE
7
Sheet1

Cell Formulas
Range	Formula
C3:C6	C3	=[@[Note_50]]>5000