Thread: if statement
View Single Post
  #3   Report Post  
mac
 
Posts: n/a
Default

Thank you. It worked just fine.

"RagDyeR" wrote:

Try this:

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

HTH,

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


"mac" wrote in message
...
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.
--
thank you mac