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!

In article <[email protected]>,
"Shorty" <[email protected]> wrote:

> 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

[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!
==============================================


"Shorty" <[email protected]> wrote in message
news:[email protected]...
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


"Shorty" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>