| 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 |
| 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 | |||
Threaded Mode
