If formula not working right

[zone709]

Hi trying to get this to work, but returns nothing blank. What am I missing? If name is present return that number ,1 ,2 or ,3

=IF(R2="Yard",1,IF(R2="Yards",2,IF(R2="Tunnel",3,"")))

 

[dado6612]

Hi trying to get this to work, but returns nothing blank. What am I missing? If name is present return that number ,1 ,2 or ,3

=IF(R2="Yard",1,IF(R2="Yards",2,IF(R2="Tunnel",3,"")))

If those are only 3 options to be in r2
=if(r2="Yard",1,if(r2="Yards",2,3))
Maybe strings are not alone in cell?

 

[gaz_chops]

Works fine for me! Are there any extra spaces or characters in R2?

 

[mrshl9898]

You could try:

=IF(TRIM(R2)="Yard",1,IF(TRIM(R2)="Yards",2,IF(TRIM(R2)="Tunnel",3,"")))

 

[gaz_chops]

You could try:

=IF(TRIM(R2)="Yard",1,IF(TRIM(R2)="Yards",2,IF(TRIM(R2)="Tunnel",3,"")))

That will work if extra spaces, but not e.g. if a CR exists.

 

[zone709]

Im not sure. In Cell R formula is pulling in the name. Can that be it?

 

[zone709]

Wait the Trim formula is working now thanks. I figured it out thanks for all the help again

 

[gaz_chops]

Type =len(R2) into another cell, see if it returns the correct number of characters

 

[Scott Huish]

There is as shorter formula, that doesn't need nested IFs though.

=IFERROR(MATCH(TRIM(R2),{"Yard","Yards","Tunnel"},0),"")

 

[zone709]

HI I came back here cause I cant get rid of this return "

If nothing returns right instead of returning blank cell like I think its suppose to. It returns " Anyone know why this returns "

Thanks


=IF(TRIM(E15)="Yard",1,IF(TRIM(E15)="Yards",2,IF(TRIM(E15)="Tunnel",3,IF(TRIM(E15)="River",4,""""))))