View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cwilliams cwilliams is offline
external usenet poster
 
Posts: 17
Default Max Value of a cell

Cell I19 is either "Yes" or "No"
Cell D15 has an annual salary
Cell I20 has a max weekly amount of 1000 based on D15 (d15/52)

Number I am trying to calculate is the weekly benefit amount based on I20
(d15/52)*60%

=IF(I19="yes",MIN(1000,D15/52*0.6),0)

Hope this explains it a lillte better.