Excel Formula Help?

[Katiemcgi]

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(G9>173200,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(G9>200000,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.

 

[Tyro]

Your formulas have an error in them. Excel does not recognize (). What do
you want if G9 is not greater than 173200? or if G9 is not greater than
200000.
Perhaps it would be better if you explain what you want to have rather than
showing formulas that don't work.

Tyro

 

[Katiemcgi]

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.

 

[Tyro]

=(G9*(0.18/10))*12/24+IF(G9>173200,2000,0)
or more simply
=G9*0.009+IF(G9>173200,2000,0)

Tyro

 

[Tyro]

I may have misunderstood you. Disregard my previous post

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

Tyro

 

[David Biddulph]

What originally calculated result? Do you mean the =(G9*(0.18/10))*12/24?
Are you saying that you don't want that *adding* to the 2000 as you've got
it?
Did you intend merely =IF(G9>173200,2000,G9*(0.18/10)*12/24) ?
If so, your result will increase in proportion to G9 until G9 reaches 173200
and the result reaches 1558.80, and then the result steps up to 2000 for all
higher values of G9. Is that what you want?
I'm even more confused if you are doing the same with the other formula, as
the G9*(0.41/100)*12/24 would reach 410 when G9 reaches 200000, and it would
seem strange if you want it then to step straight from 410 to 10000.