We have 2 add-in SW vendors which return values with comments to a cell. I
want to check the vendor ID in cell comment to determine if I need to do a
calculation on value. Is that possible via a simple formula or is a macro or
something more complicated required? Is it even possible?

We are using MS Excel 2003.