Max Value of a cell
Cindy:
MAX should be MIN
I make that mistake all the time : \
Try this:
=IF(I19="yes",MIN(1000,D15/52*0.6),0)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"cwilliams" wrote:
I entered that formula and it is not calculating if the value is under 1000
only if it is over 1000. Maybe the 1000 is in the wrong place?
=IF(I19="yes",MAX(1000,D15/52*0.6),0)
|