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

On Mon, 14 Nov 2005 16:43:49 -0000, "Dave 2005"
wrote:

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


=IF(H2=10,0,H2)


--ron

=h2*(h2<10)


"Dave 2005" wrote:

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

How about
=IF(H210,0,H2)

Dave 2005 Wrote:
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

Hi Dave

Try this ----- =IF(H2,MIN(10,H2),0)


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=484900

=IF(H4=10,MIN(10,H4,0),H4)

for equal or larger than 10

"Dave O" wrote:

How about
=IF(H210,0,H2)