Forum Discussion

ChrisC365's avatar
ChrisC365
Brass Contributor
Feb 04, 2020
Solved

How to identify letter combinations in a cell value

Hi Needing some help with identifying what type of grant I have on worksheet using a formula.  Each grant  has its own project code, the format or letters dictate what category of award it its.  For...
excel
  • Charla74's avatar
    Charla74
    Feb 04, 2020
    ChrisC365

    This formula would work but assumes that what you have displayed is the complete list:

    =IF(LEFT(B3,2)="RS","INTERNAL GRANT",IF(LEFT(B3,1)="D","GENERAL GRANT","KEY GRANT"))
Charla74's avatar
Charla74
Iron Contributor
Feb 04, 2020
ChrisC365

This formula would work but assumes that what you have displayed is the complete list:

=IF(LEFT(B3,2)="RS","INTERNAL GRANT",IF(LEFT(B3,1)="D","GENERAL GRANT","KEY GRANT"))
ChrisC365's avatar
ChrisC365
Brass Contributor
Feb 04, 2020

Charla74 

 

Many thanks, I can now where I have been going wrong, I have been adding the OR function to my IF statement. Your solution works great thanks.

 

Chris

Resources