How to return an answer inside parenthesis ?

[SHood]

Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I'd like to run an IF function that will compare two cells and return a blank if equal and return one of the cells contents inside of parenthesis if not.

something like

=IF(C1=H1,"",C1)

but the C1 name returned would look like (name)

 

[Harvey Waxman]

=IF(C1=H1,"",C1)

but the C1 name returned would look like (name)

=IF(C1=H1,"","("&C1&")")

Does this work?

 

[SHood]

Yes it did - Thanks