multiple "IF" not working as expected

[Rhots]

Hi, it's been a while for me so I need some help

=IF(T3="208Y/120",208,OR(IF(T3="480Y/277",480,OR(IF(T3="240d/120",240)))))


T3 is data validation with a list, the first part works correctly, ie. 208y/120 returns 208, the other 2 return "true" rather than 480 or 240.

Thanks for your help,
Rick

 

[Joe4]

Try getting rid of the OR statements. That is not how you use them. You use OR when you have multiple different values to check for that should return the same single value.

I think you just want:

[COLOR=#333333]=IF(T3="208Y/120",208,IF(T3="480Y/277",480,IF(T3="240d/120",240)))[/COLOR]

 

[Scott T]

You do not need the ORs

=IF(T3="208Y/120",208,IF(T3="480Y/277",480,(IF(T3="240d/120",240))))

 

[Rhots]

thanks guys, that works great.....is there a better way?

 

[Scott T]

Do not know if it is "better" but you could also do a Vlookup

=VLOOKUP(T3,{"208Y/120",208;"480Y/277",480;"240d/120",240},2,0)

 

[Joe4]

It looks like you are just wanting the first 3 characters of the entry in T3.
So why not just:

=LEFT(T3,3)

 

[Rhots]

thanks, I'll give it a try, never used vlookup

 

[Joe4]

With VLOOKUP, you usually have a list that you refer to. You typically see VLOOKUP used when you have a bunch of different options, or allow for inexact matches.
See: https://www.techonthenet.com/excel/formulas/vlookup.php

Note, did you see my last post? If your example is really indicative of the data you are working with, this may be even easier than you think!