Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a conditional formula to replace
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" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a conditional formula to replace
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 "dot" wrote: 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" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a conditional formula to replace
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
NEED TO CREATE A CONDITIONAL FORMULA | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) |