I have a column that will contain several numbers (between 1-4) in each cell depending on answers from a survey. ie 1,2,3,4 or 3,4 or 1,2,3
In a separate column i need to have just one single number, which, because the answers escalate means that i just need the lowest value returned. Ie if 1,2,3,4, i need 1. If 3,4 i want to return 3.
From what i understand, I could do this easily enough using the MIN function. However due how the question was asked, if the responds lowest number was 1, I need to enter a 4 into the database, If 2 than 3, 3 than 2, and 4 than 1.
My thought was to use several IF statements that IF the MIN value = 1, than return 4 etc. However, I'm not sure if this is the most effective way to go about it.
Thanks for any help!!
=IFERROR(5-VALUE(LEFT(TRIM(A1);1));"")
returns the correct resultswitch
orchoose
as a substitute for nestedif
orifs
. The unknown to me is if you have a response of1,2,3
is the translated value supposed to be 4 or 3?