if statement

M

mac

I have a row of cells (a54:g70) that I would like to say if they have any
text in them to "fix errors", and if no text say "okay". I have tried to do
this and I keep coming up with a value. What am I doing wrong. Any help is
greatly appreciated.
 
R

RagDyeR

Try this:

=IF(COUNTIF(A54:G70,"*?")>0,"Fix Errors","Okay")
--

HTH,

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


I have a row of cells (a54:g70) that I would like to say if they have any
text in them to "fix errors", and if no text say "okay". I have tried to do
this and I keep coming up with a value. What am I doing wrong. Any help is
greatly appreciated.
 
Top