Share via

IF FORMULA

Anonymous
2019-10-04T02:40:07+00:00

HELLO!  PLEASE HELP!!

I WANT TO DO AN "IF" FUNCTION:

IF B10 IS > OR = TO 200000, IF CONDITION IS TRUE,  THEN MULTIPLY BY  0.35.

IF FALSE, THEN MULTIPLY BY O.27

I CAME UP WITH 

=IF(OR(B10>=200000,)*(B1O*0.35) ","*(B10*0.27)*")

BUT IT TELLS ME THAT ITS WRONG--GEEZ I AM NEW TO THIS-AND AM TRYING TO LEARN   HELPPPPPP

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

Anonymous
2019-10-04T03:07:24+00:00

Hello! I am an Independent Advisor, I would love to help you out!

I believe you are looking for something like this:

=IF(B10>=200000,B10*0.35, B10*0.27)

Try it out and let me know if it needs modifications, or if you need anything else.

Was this answer helpful?

30+ people found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2019-10-04T02:55:05+00:00

Jeanie,

  =IF(B10>=200000, B10*0.35, B10*0.27)

Was this answer helpful?

10+ people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-10-04T05:49:09+00:00

    THANK YOU THANK YOU THANK YOU    WORKED GREAT!!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-10-04T03:23:37+00:00

    THANKS A MILLION! WORKED JUST GREAT!!!!!

    Was this answer helpful?

    0 comments