IF formula

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

i have columns that contain names of insurance companies followed by their
type. example
aetna grp
progressive pip
cigna wc

i would like to write a formula that would result in a 1, 2, or 3
corresponding to the type (grp, pip, wc)

i'm thinking the formula would read
'if this cell contains 'grp' = 1, 'pip'=2, 'wc'=3'

i cannot figure out how to write this formula

thanks MS group
 
See your 2nd post for a formula where name & type are in the same cell.

Mike F
 
To avoid an error flag when the cell is blank, use this version:


=IF(B1="GRP",1,IF(B1="PIP",2,IF(B1="WC",3,"")))
 
Back
Top