I need help! I am looking for a formula to know if "yes" or "no" a percentage between two columns equals 12% in excel 2016. This should be simple but for some reason the ones I have created failed.

For example:

This is manually done:

Total Amount | Amount Discounted | Discount Applied |

$ 1,702,349.66 | $ 204,281.96 | Yes - 12% Discount |

$ 1,065,846.67 | $ 127,901.60 | Yes - 12% Discount |

With Formula:

=IF(H13/G13-1,"yes","no")

Total Amount | Amount Discounted | Discount Applied |

$ 1,702,349.66 | $ 204,281.96 | yes |

$ 1,065,846.67 | $ 127,901.60 | yes |

Using the same formula:

=IF(H13/G13-1,"yes","no")

Total Amount | Amount Discounted | Discount Applied |

$ 1,702,349.66 | $ 204,281.96 | yes |

$ 1,065,846.67 | $ 204,281.96 | yes |

The answer under the "Discount Applied" column should say "no" instead.

I have also tried:

=IF(AND(H13/G13>=12%,H13/G13<=12%),"Yes","No")

=IF(AVERAGE(G13:H13)=12,"yes","no")

=IF(AVERAGE(G13:H13)>=12,IF(AVERAGE(G13:H13)<=12,"yes","no"))

=IF(H13/G13-1,"YES","NO")

It might be fairly simple but for some reason I cannot get to it. Can someone please shed some light?

Thanks!