formula help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shorty - 26 Jun 2005 00:14 GMT

I need an IF formula for cells c5 through h5, If a number is entered as a
negative then an error message should appear in cell b10 that says "Error"

Thank You

Reply to this Message

Domenic - 26 Jun 2005 00:34 GMT

Try...

=IF(COUNTIF(C5:H5,"<0"),"Error","")

Hope this helps!

> I need an IF formula for cells c5 through h5, If a number is entered as a
> negative then an error message should appear in cell b10 that says "Error"
>
> Thank You

Reply to this Message

RagDyeR - 26 Jun 2005 00:34 GMT

Assume zero and above is OK:

=IF(COUNTIF(C5:H5,"<0")>0,"Error","OK")

Signature

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I need an IF formula for cells c5 through h5, If a number is entered as a
negative then an error message should appear in cell b10 that says "Error"

Thank You

Reply to this Message

CLR - 26 Jun 2005 01:34 GMT

=IF(MIN(C5:H5)<0,"Error","")

Vaya con Dios,
Chuck, CABGx3

> I need an IF formula for cells c5 through h5, If a number is entered as a
> negative then an error message should appear in cell b10 that says "Error"
>
> Thank You

Reply to this Message