formula help

  • Thread starter Thread starter Shorty
  • Start date Start date
S

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
 
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
 
Back
Top