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]
