Share via

If function

Anonymous
2022-04-29T05:58:56+00:00

Hi, I need help.

i need a formula: if cell A2 is less than 3000, then the answer is 0, if A2 is between 3000 and 4999, then the result is A2 x 0.02, if A2 is equal to or greater than 5000, the result is A2 x 0.04

[Moved from: Excel/Other/Unknown]

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

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-29T09:09:11+00:00

    Hi AnneLall,

    Try this if it helps:

    =IFS(A2<3000,0,AND(A2>=3000,A2<=4999),A2*0.02,A2>=5000,A2*0.04)

    Regards,

    Ryan

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-04-29T06:28:52+00:00

    it doesn't work, maybe i did something wrong :(

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-04-29T06:20:13+00:00

    You are welcome.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-04-29T06:18:55+00:00

    thank Yuo :)

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-04-29T06:17:13+00:00

    Hi,

    Try this formula:

    =LOOKUP(A2,{0,3000,5000},A2*{0,0.02,0.04})

    Hope this helps.

    Was this answer helpful?

    0 comments