Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 05, 10:06 AM
DaveMoore
 
Posts: n/a
Default Cell C1 ="error" if....

I wish to return the text "Error" in cell C1 if the text "error"
appears in any cell in the range AF3:AF52. Cells in the range
AF3:AF52 contain a formula that reurns "error" if there should be a
problem in that row.
Can anyone advise?
Thanks to all,
Dave Moore


  #2   Report Post  
Old May 20th 05, 10:27 AM
Mangesh
 
Posts: n/a
Default

Enter the following formula in C1:

=IF(COUNTIF(AF3:AF52,"Error")0,"Error","")


Mangesh



"DaveMoore" wrote in message
oups.com...
I wish to return the text "Error" in cell C1 if the text "error"
appears in any cell in the range AF3:AF52. Cells in the range
AF3:AF52 contain a formula that reurns "error" if there should be a
problem in that row.
Can anyone advise?
Thanks to all,
Dave Moore



  #3   Report Post  
Old May 20th 05, 10:57 AM
DaveMoore
 
Posts: n/a
Default

Thanks, Mangesh.
Simple really, wasn't it?
But I couldn't see it!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AutoFIll -by dragging the bottom-right corner of the cell Venkatesh V Excel Discussion (Misc queries) 5 February 23rd 05 04:57 PM
how to create a variable column in cell reference Sampson Excel Worksheet Functions 3 February 21st 05 10:13 PM
Can a Formula in Cell X modify Cell Y? alMandragor Excel Discussion (Misc queries) 7 February 10th 05 09:51 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017