Need Help

[Dave 2005]

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

 

[Ron Rosenfeld]

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

 

[Duke Carey]

=h2*(h2<10)

 

[Dave O]

How about
=IF(H2>10,0,H2)

 

[Paul Sheppard]

Hi

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

The formula is returning 10 if the cell is 10 or over, is somethin
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

 

[ufo_pilot]

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

for equal or larger than 10