View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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