ExcelBanter - if statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if statement (https://www.excelbanter.com/excel-worksheet-functions/22317-if-statement.html)

mac

if statement

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

RagDyeR

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

mac

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

All times are GMT +1. The time now is 04:22 AM.