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
|