Share via

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
  1. riny 20,525 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.

    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

    0 comments