Max Value of a cell
I hit another road block with my formula.
=IF(I19="yes",(((D15/52)*0.6)),0)
The max value can only be $1,000. How do I tell it if D15/52*60% is more
then $1,000 only enter $1,000. If the value is less then $1,000 then enter
the number from the formula. If I19 is no then 0 still needs to be used.
Thanks again to everyone!
|