Anthony,
Thanks for the tips. They worked with jus a slight change. I needed a
semi colon between the value and cell in the find part of the statement.
Thanks a bunch,
Rick Knight
Anthony Chilco wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
