Share via

IF Statement, Between Numbers

Anonymous
2014-02-20T20:07:14+00:00

Looking to create an IF formula for the following. I have it started but cannot complete. I know how to do each individual IF formula, just mot each condition together.

IF Cell is less than .10, return 0, if between .10 and .20, return 1, if between .2 and 1, return 2.

=IF(F2<0.1, 0)

=IF(OR(F2>=0.1, F2<0.2),1)

=IF(OR(F2>=.2, F2<1),2)

Thanks!

Microsoft 365 and Office | Excel | For home | 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

Ashish Mathur 101.9K Reputation points Volunteer Moderator
2014-02-20T23:50:15+00:00

Hi,

Try this

=IF(F2<0.1,0,IF(F2<0.2,1,2))

Hope this helps.

Was this answer helpful?

0 comments

11 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-02-21T13:45:28+00:00

    Correct, it is a percentage.

    Was this answer helpful?

    0 comments
  2. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2014-02-21T00:41:39+00:00

    Hi,

    From the original question, it appears that F2 will have a maximum value of 1.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-02-21T00:27:08+00:00

    =IF(F2<0.1,0,IF(F2<0.2,1,2))

    What is F2 is 5?

    IF Cell is less than .10, return 0, if between .10 and .20, return 1, if between .2 and 1, return 2.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-02-20T20:19:17+00:00

    Try this boolean version,

    =((F2>=0.1)+(F2>=0.2))*(F2<1)

    Was this answer helpful?

    0 comments