I20 doesn't appear anywhere in your formula (to add to the confusion) but you
say it has a maximum of 1000 based on D15/52; so if D15=62,400 then
D15/52=1200 which exceeds your maximum of 1000.

Are you saying compare 1200 with 1000, choose the smallest i.e. 1000 and
multiply this by 0.6?

if so, this will be the formula

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

if D15=52,100 result is 600 (1000*0.6)

if D15=50,000 result is 576.92 (50000/52)*0.6

"cwilliams" wrote:

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.