If function return value_if_true despite logical test is false

Anonymous
2023-03-05T04:47:44+00:00

I need to check whether the value in F9 is greater than 100, but the return value is always true despite the data in F9 is 50

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

riny 20,950 Reputation points Volunteer Moderator
2023-03-05T05:02:09+00:00

The 'number' 50 in F9 is a text. So you are comparing a text with a number. Change the formula to this:

=VALUE(F9)>=100

That should fix it. No need for an IF(OR(........),"TRUE","FALSE") type of function. The one above will return TRUE or FALSE depending on the VALUE of what's in F9.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-05T05:44:43+00:00

    Hi Qm.n!

    I am Shakiru, an independent advisor and a user like you, and I am glad to be helping you out today.

    Use the simple function below, it should return false except the value in F9 is not rightly formatted =F9>100

    Note: Check the cell format: Check if cell F9 is formatted as text instead of a number. If the cell is formatted as text, Excel will not be able to recognize it as a number and will always return a true value.

    Best Regards, Shakiru

    Was this answer helpful?

    0 comments