ur method worked but, i can't understand how did it caluculate?
MIN(a1:a100) returns the value which is minimum in that cell range.
isn't it? and if that is less than 40........... ?????
i can't understand the logic.
can u please explain me?
Thanks in advance.