Create a conditional formula to replace

D

dot

Hi,
How could I check if the cell in a column starts with a certain alphabet, if
yes, then in a different columns cell add the word "DONE"
eg: validate column P, if a cell starts with XYZ, then in coulmn B, of the
same row, add the word "DONE"
 
R

Ron Coderre

Try this:

B1: =IF(LEFT(P1,3)="XYZ","DONE","")
OR
B1: =IF(COUNTIF(P1,"XYZ*"),"DONE","")

Copy either of those formulas down

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
P

Pete_UK

Enter this is B2:

=IF(LEFT(P2,3)="XYZ","DONE","")

This leaves B2 blank if P2 does not start with XYZ. Copy the formula
down as necessary.

Hope this helps.

Pete
 
Top