Hi

This =IF(H2,MIN(10,H2),0) returns the numbers from column H with a maximum
of 10.

The formula is returning 10 if the cell is 10 or over, is something wrong.

Question: I need it to return 0 if 10 or over.

Microsoft Excel 2002

Thanks in advance

Dave