IF FORMULA

Question

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

Answer 1

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.

Answer 2

Jeanie,

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

Answer 3

THANK YOU THANK YOU THANK YOU    WORKED GREAT!!

Answer 4

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