Multiple results in one cell

[Lildumy]

I need to have one cell that will display multiple results when data is entered.
EX: =IF(A33="gts-320",4.8,0)
I need to add several more to this cell. =IF(A33="gts-320",4.8,0)=IF(A33="gts-520",4.8,0) and so on. The single command works but when I add the next one it will not work.
I am very new to this. Any help would be great. I have 4 total i need this cell to work with.
JC

[tlafferty]

=

Please Login or Register  to view this content.

[JBeaucaire]

Almost... one small tweak:

=IF(OR(A33={"gts-320","gts-520"}),4.8,0)

[tlafferty]

Oops - you're right! Thanks!

[Lildumy]

I made a typo on this =IF(A33="gts-320",4.8,0)=IF(A33="gts-520",5.2,0) I copied the code and didn't change the values on the second line. Basically I need this to give me different results when I type in gts-320 it should be 4.8, gts-520 should be5.2, gts-710 should be 5.6. sorry its confusing.

[Lildumy]

=IF(A33={"gts-320","gts-520,"},4.8,5.2),IF(A33={"gts-710","gts-910,"},5.6,8)
Something like this is what I need to do. Wont work but I'm still trying

[tlafferty]

Please Login or Register  to view this content.

This should give you what you want. If A33 contains anything other than the gts values you were testing for, the function will return Val not found. For gts-320 if resturns 4.8, for gts-520, 5.2, for gts-710, 5.6.

[Lildumy]

=IF(A33="gts-320",4.8,IF(A33="gts-520",5.2,IF(A33="gts-710",5.6,IF(A33="gts-910",8,"Val not found"))))
This is how I modified it to add 1 more function.Viola....it works!!!

Thank you, thank you, Thank you
JC

[nadarajan]

Prepare a table say in E and F coloumn.Say gts-320,gts-520 in E column and the corresponding
value in F column. And use the function =VLOOKUP(A33,E:F,2,0). you will get the desired result
MN

[JBeaucaire]

You should consider creating a lookup table to make editing these values easy. Read up on the VLOOKUP() function.

[nadarajan]

IF limited to only 7 ,but VLOOKUP you can add as you like.I thought Lildumy having more than 7 MN