Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Help?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Help?
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Help?
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Help?
=(G9*(0.18/10))*12/24+IF(G9173200,2000,0)
or more simply =G9*0.009+IF(G9173200,2000,0) 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Help?
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Help?
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(G9173200,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. -- David Biddulph "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions |