Max Value of a cell
That is not it either. If the cell is "yes" and the amount is less then 1000
then it needs to used the formula D15/52*.6 and if the amount is over 1000
then it should just put 1000 in the cell. If the cell is "no" then it should
not do anything but put 0 in it.
Not sure if I am explaining this too well.
"Nobody" wrote:
Change MAX to MIN
Hope I help you
"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)
|