Help on IF function

Copper Contributor

Any idea on why is it returning true?

 

rennats_1-1703839532769.png

 

 

 

3 Replies

@rennats Texts are considered greater than numbers. That's why.

 

By the way, you can simplify the formula to:

=A2>1000

This will return either TRUE or FALSE. No need for the IF in this case.

 

But since this is apparently not what you really want, can you explain what is you are expecting and why?

@Riny_van_Eekelen 

 

Yeah sorry I was really using the IFS function, I just simplified the formula above.

Below is the my sample IFS.

 

rennats_0-1703840351392.png

 

Something to bear in mind is that the comparison operators also apply to the alphabetical sort order of text, thus

= IFS(
    A1>"asdz", "AFTER 'asdz'",
    A1>"asd",  "AFTER 'asd'",
    TRUE,      "BEFORE OR EQUAL TO 'asd'"
  )

are valid as text comparisons.