If Statement to display 3 different outputs instead of 2
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. |
If Statement to display 3 different outputs instead of 2
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. |
If Statement to display 3 different outputs instead of 2
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. |
If Statement to display 3 different outputs instead of 2
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. |
If Statement to display 3 different outputs instead of 2
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. |
If Statement to display 3 different outputs instead of 2
=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. |
All times are GMT +1. The time now is 03:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com