| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula of two numbers if greater than 500
How do I create a formula that divides annual pay by 52 weeks and if the pay
is over 500 dollars for that week the answer defaults to 500.00 31,200 divided by 52 weeks equals 600.00 but I need the max number in the field to go to 500.00 ,if the pay is over 500.00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula of two numbers if greater than 500
If I understand:
=MIN(500,pay/52) Biff "deb" wrote in message ... How do I create a formula that divides annual pay by 52 weeks and if the pay is over 500 dollars for that week the answer defaults to 500.00 31,200 divided by 52 weeks equals 600.00 but I need the max number in the field to go to 500.00 ,if the pay is over 500.00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula of two numbers if greater than 500
If I have in cell c7 annual pay 31200 and in cell d7 the formula to divide
the c7by 52 to give me a weekly salary rate. The next cell over e7 or can I have two formulas in d7 to . I need the answer to be the weekly salary of anything less than 500 to go into the cell and if over 500 per week the cell defaults to $500.00 Why, I need this is that I need to calculate the next formula on insurance premiums on weekly salary. The max the insurance will pay is 500.00 weekly annual pay...........weekly pay...........if over 500 default to 500 CELL c7....................d7.......................e7. ............. 31,200 ....................600......................500.0 0 15,000..................288.47.................... .288.47 "deb" wrote: How do I create a formula that divides annual pay by 52 weeks and if the pay is over 500 dollars for that week the answer defaults to 500.00 31,200 divided by 52 weeks equals 600.00 but I need the max number in the field to go to 500.00 ,if the pay is over 500.00 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula of two numbers if greater than 500
Try this in D7:
=MIN(500,ROUND(C7/52,2)) Biff "deb" wrote in message ... If I have in cell c7 annual pay 31200 and in cell d7 the formula to divide the c7by 52 to give me a weekly salary rate. The next cell over e7 or can I have two formulas in d7 to . I need the answer to be the weekly salary of anything less than 500 to go into the cell and if over 500 per week the cell defaults to $500.00 Why, I need this is that I need to calculate the next formula on insurance premiums on weekly salary. The max the insurance will pay is 500.00 weekly annual pay...........weekly pay...........if over 500 default to 500 CELL c7....................d7.......................e7. ............. 31,200 ....................600......................500.0 0 15,000..................288.47.................... .288.47 "deb" wrote: How do I create a formula that divides annual pay by 52 weeks and if the pay is over 500 dollars for that week the answer defaults to 500.00 31,200 divided by 52 weeks equals 600.00 but I need the max number in the field to go to 500.00 ,if the pay is over 500.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatic comas for numbers greater than 999 | New Users to Excel | |||
| the greater of 2 numbers | New Users to Excel | |||
| How to summarize the first 4 numbers greater than 0 from a list. | Excel Worksheet Functions | |||
| How can I superscript numbers greater than 3? | Excel Discussion (Misc queries) | |||
| greater than replace numbers | Excel Worksheet Functions | |||
Linear Mode
