Hi Rick,
Use the 'find' function to look for the absence of 'R'.
=If(iserror(find("R",b2);"";MyComment)
You could just look for the 'R' like this:
=If(find("R",b2);MyComment;"")
But cases without the 'R' will return 'N/A'.
tc
Rick Knight wrote:
I want to set a cell's contents based on the contents of another cell.
For example...
In column 2 I have a list of model numbers, some of which contain (R). I
want column 8 to contain a comment if the corresponding cell in column 2
contains (R), other wise the cell in column 8 will be left empty. I've
tried various forms of this...
IF (A2=sometextornumbers(R);MyComment;"")
But all I get is #name and error "invalid name". Can someone suggest how
I can use IF to get the results I'm after?
Thanks,
Rick Knight
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
