I may have misunderstood you. Disregard my previous post

=IF(G9173200,2000,G9*0.18/10*12/24)
or more simply
=IF(G9173200,2000,G9*0.009)

Tyro


"Katiemcgi" wrote in message
...
Thanks, That is my problem if G9 is not greater than 173200 than I want
the
orig. calculated result left. How do I state this in the (_) If the G9 is
greater than 173200 than I would like the weekly benefit to be 2000.

"Katiemcgi" wrote:

Hi, I'm trying to create the following two formulas in two separate
columns.

Column G (Annual Salary) Column J (STD Benefit) Column K (LTD Benefit)

In Column J My Formula is =(G9*(0.18/10))*12/24+IF(G9173200,2000,())
Where
weekly benefit amount cannot exceed $2,000. I'm not sure how to tell my
False response to stay with the original formula result.

In Column K My Formula is =(G9*(0.41/100)*12/24+IF(G9200000,10000,())
Where
monthly benefit amount cannot exceed $10,000. I'm not sure how to tell my
False response to stay with the original formula result

But, I'm trying to return with the Per Pay Period Benefit Amount in the
Cell.