PDA

View Full Version : XL - Formula - If a cell contain just this text, display some other text in this cell.Check a cell



12-08-2000, 08:33 PM
I would like a formula, that checks if a cell contains some of this text,
display some other text in the next cell.

Say I have Ford Explorer in cell A1(could be Ford Pinto or another Ford
model), I need a formula in cell B2 which checks Cell A1 for the word Ford,
then displays Petrol, but leaves it blank otherwise.

Thanks....John