I am trying to use an if statement to get 1 of a possible 3 inputs and then
display in a more human friendly manner, for example.

The 3 inputs a

p
n
o

If someone types in p then I would like to have Passed displayed, f should
display failed and o should display other. It works great if there are just
2 options but I cannot seem to find a solution for 3 variables.

Try

=IF(A1="P","Passed",(IF(A1="f","Failed",IF(A1="o", "Other",""))))

If this post helps click Yes
---------------
Jacob Skaria


"MikeyB" wrote:

I am trying to use an if statement to get 1 of a possible 3 inputs and then
display in a more human friendly manner, for example.

The 3 inputs a

p
n
o

If someone types in p then I would like to have Passed displayed, f should
display failed and o should display other. It works great if there are just
2 options but I cannot seem to find a solution for 3 variables.

Hi,

Try this

=LOOKUP(A1,{"F","O","P"},{"Failed","Other","Passed "})

Mike

"MikeyB" wrote:

I am trying to use an if statement to get 1 of a possible 3 inputs and then
display in a more human friendly manner, for example.

The 3 inputs a

p
n
o

If someone types in p then I would like to have Passed displayed, f should
display failed and o should display other. It works great if there are just
2 options but I cannot seem to find a solution for 3 variables.

Wow, thanks Jacob, that got it working a treat!

"Jacob Skaria" wrote:

Try

=IF(A1="P","Passed",(IF(A1="f","Failed",IF(A1="o", "Other",""))))

If this post helps click Yes
---------------
Jacob Skaria


"MikeyB" wrote:

I am trying to use an if statement to get 1 of a possible 3 inputs and then
display in a more human friendly manner, for example.

The 3 inputs a

p
n
o

If someone types in p then I would like to have Passed displayed, f should
display failed and o should display other. It works great if there are just
2 options but I cannot seem to find a solution for 3 variables.

One easier way to tackle the several options is via using VLOOKUP
Assuming the data: p, f, o (presume you had a typo when you said: n ?)
would be entered in A2 down
you could have this in B2:
=IF(A2="","",VLOOKUP(A2,{"p","Passed";"f","Failed" ;"o","Other"},2,0))
Copy B2 down as far as required
aloha? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---


"MikeyB" wrote:

I am trying to use an if statement to get 1 of a possible 3 inputs and then
display in a more human friendly manner, for example.

The 3 inputs a

p
n
o

If someone types in p then I would like to have Passed displayed, f should
display failed and o should display other. It works great if there are just
2 options but I cannot seem to find a solution for 3 variables.

=INDEX({"Passed","Failed","Other"},MATCH(A1,{"P"," F","O"},))


"MikeyB" wrote:

I am trying to use an if statement to get 1 of a possible 3 inputs and then
display in a more human friendly manner, for example.

The 3 inputs a

p
n
o

If someone types in p then I would like to have Passed displayed, f should
display failed and o should display other. It works great if there are just
2 options but I cannot seem to find a solution for 3 variables.