IF statement not doing anything if condition met

[Hapdawg88]

=IF($DF2=5,"5/6", IF($DF2=6,"5/6",$DF2))

I have put this formula in column DG. I would like for it to change all of the 5's and 6's in column DF to 5/6 and the leave the other values as they are . Currently, it is leaving all of the values as they are - not changing 5 and 6 to 5/6.

Any idea what I am doing wrong?

 

[Aryatect]

Hi,
Check if the DF column has number stored as text, Put in column DH =ISNUMBER(DG2). Your formula is working for me.

 

[Fluff]

You can simplify that formula like
=IF(OR(DF2={5,6}),"5/6",DF2)
However as Aryatect said you need to check if the values in DF are text or numbers.
You also need to check that they are exactly 5 or 6, rather than 5.1 which are set to display as 5

 

[Hapdawg88]

The values in DF are numbers and 'NA'. I highlighted the column and formatted cells as numbers but it did not help.

You can simplify that formula like
=IF(OR(DF2={5,6}),"5/6",DF2)
However as Aryatect said you need to check if the values in DF are text or numbers.
You also need to check that they are exactly 5 or 6, rather than 5.1 which are set to display as 5

 

[Fluff]

Did you try what @Aryatect suggested in post#2 & what did it return?