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