| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
| What statement to use? | Excel Worksheet Functions | |||
| How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
Linear Mode
