Trouble creating a formula with 3 possible answers

[JamieSarra]

Hi!
I have been trying to create a formula that will generate 1 of 3 possible answers with no luck. Here is what I need to happen:
In column F if the total equals 3 or 4 then in column G the answer generated needs to be a 2.
In column F if the total equals 5 or 6 then in column G the answer generated needs to be a 3.
In column F if the total equals 7 or 8 then in column G the answer generated needs to be a 4.

I've tried some IF formulas and some with AND that I found online and through help searches, but most formulas, I found were for only 2 possible answers, not 3. Please help, if you can. Thanks!

 

[etaf]

use a nested formula

=IF( OR(F_Total_Cell =3 , F_Total_Cell = 4), 2, IF(OR(F_Total_Cell =5 , F_Total_Cell = 6), 3, IF( OR(F_Total_Cell =7 , F_Total_Cell = 8), 4, "cell does not meet criteria")))

 

[Weazel]

maybe...

=LOOKUP(A2,{0;3;5;7},{0;2;3;4})

 

[Special-K99]

Try
LOOKUP(F1,{3,5,7},{2,3,4})

where F1 is your column total

Alternatively if you know that the column total values can ONLY be 3,4,5,6,7,8 you could simply use this:

=INT(F1+1)/2

 

[JamieSarra]

Thank you for your help. I will try that and let you know if it works.