Incorporating Percentages to Excel IF Formulas %?

How ever incorporate %’s in to Excel WHEN formulas As an example, my mentor threw this specific in by the end of the assignment::

Put a offering charge to customer totals:10% whenever over $200; in any other case 15%

I keep attempting to put “=IF(H2>$200, 10% associated with H2, 15% associated with H2)”
In this case H2 is usually $81.50

Naturally, I know I cant squeeze word “of” as well as expect it to be effective so Now i am confused within the correct formatting.

You are within the right course…

the formula inside cell need to be:

=if(H2>200, h2*.YOU, h2*.15)

and that will accomplish the trick

syntax is:
=if(condition, whenever true, or true)

Everyone.

This should do the trick:

=IF(H2>200, H2+H2*0.YOU, H2+H2*0.15)

The following says, that if H2 is in excess of 200, take on-line of H2 and enhance that 10% associated with H2 or even if H2 is lower than or add up to 200 take the worthiness of H2 and help to increase that 15% with H2.