Returns value even thought there is no value

[jimbojames136]

Hi Guys,

 

wondering if anyone can help me spot what im doing wrong.

I have 3 columns and a lookup table

 

Column 1

Contains a Grade (A,B,C etc)

 

Column 2

Lookups up the Value of that grade, with an iferror to stop #N/A

=IFERROR(VLOOKUP([@Maths],Grade_to_Points,2,FALSE),"")

 

Column 3

looks at Column 2 and if the value is greater than 5 return M

=IF([@[Maths Points]]>=5,"M","")

 

 

Now the problem I have is Column 3 returns M for every Cell, even though column 2 cells are blank......

what am I missing?

 

any help much appreciated.

 

thanks

James