ExcelBanter - Is an "IF" statement appropriate?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Is an "IF" statement appropriate? (https://www.excelbanter.com/excel-worksheet-functions/177010-if-statement-appropriate.html)

DaveMoore

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

Mike H

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

All times are GMT +1. The time now is 03:44 AM.