Need IF statement but not sure how or which to use

[Capsaicin Burn]

I need to determine if a cell is greater than a number then perform one calculation and if its less than then perform a another calculation.

Example:

If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10

If A1 is greater than 500 then subtract 250 and multiply it by 12% or .12

All numbers could be cell references or just numbers.

All of my google searches are to vague to help he with this. Most of what I find tells me how to display text based on cell values.

As always, any help is greatly appreciated.

Jim

 

[footoo]

=if(a1<=500,(a1-200)*0.1,(a1-250)*0.12)

 

[Capsaicin Burn]

=if(a1<=500,(a1-200)*0.1,(a1-250)*0.12)

Wow, It worked perfectly. Thank You!

I have a lot to learn but I work on it daily.