Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is an "IF" statement appropriate?
Hi all.
I want a formula that looks at another cell, and if that cell Begins With "NPM" then return "Y". Is an "IF" statement required, if so how will it read? If not, what formula will do the job? Regards, Dave Moore |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is an "IF" statement appropriate?
Try this
=IF(LEFT(A1,3)="NPM","Y","N") Mike "DaveMoore" wrote: Hi all. I want a formula that looks at another cell, and if that cell Begins With "NPM" then return "Y". Is an "IF" statement required, if so how will it read? If not, what formula will do the job? Regards, Dave Moore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"IF" statement & "strikethrough" formatting | Excel Worksheet Functions |