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.
|