formula help

[Shorty]

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

 

[Domenic]

Try...

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

Hope this helps!

 

[RagDyeR]

Assume zero and above is OK:

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

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

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3