Multipart IF depending on % in another column and number in this column

[NGB82KS]

G	H	I	J
97%	7.00	=IF(ISBLANK(H:H),"ERROR",IF(H:H>=3.5,"CRITICAL",IF(AND(H:H<=3.49,H:H>=2.5),"MODERATE","ACCEPTABLE")))	HELP??

So, my code for Column I is working as intended, but I need help to add an additional portion to the code for column J.
What i need is the following in code form, because i cant seem to figure out column J.
I tried wrapping in ANDs but i keep erroring out and im sure it's something stupid im missing

if Column G:G >=95% and Column H:H >=3.5 then write "CRITICAL ",
if Column G:G <=95% and Column H:H >=3.5 then write "CRITICAL wAR",
if Column G:G >=95% and Column H:H <=3.49 & >=2.5 then write "MODERATE",
if Column G:G <=95% and Column H:H <=3.49 & >=2.5 then write "MODERATE wAR",
if Column G:G >=95% and Column H:H <2.5 then write "ACCEPTABLE",
if Column G:G <=95% and Column H:H <2.5 then write "ACCEPTABLE wAR",

 

[jasonb75]

Should it be >=95% or <=95%? Only one can be equal, not both. Assuming that it should be >=95% or <95% this should work.

=LOOKUP(H2,{0,2.5,3.5},{"CRITICAL","MODERATE","ACCEPTABLE"})&IF(G2<95%," wAR","")

 

[NGB82KS]

Should it be >=95% or <=95%? Only one can be equal, not both. Assuming that it should be >=95% or <95% this should work.

=LOOKUP(H2,{0,2.5,3.5},{"CRITICAL","MODERATE","ACCEPTABLE"})&IF(G2<95%," wAR","")

Oops, yeah sorry it should be

if Column G:G >=95% and Column H:H >=3.5 then write "CRITICAL ",
if Column G:G <95% and Column H:H >=3.5 then write "CRITICAL wAR",
if Column G:G >=95% and Column H:H <=3.49 & >=2.5 then write "MODERATE",
if Column G:G <95% and Column H:H <=3.49 & >=2.5 then write "MODERATE wAR",
if Column G:G >=95% and Column H:H <2.5 then write "ACCEPTABLE",
if Column G:G <95% and Column H:H <2.5 then write "ACCEPTABLE wAR",

 

[jasonb75]

In that case, the formula that I suggested should work, although I did miss the part for blanks in your attempted formula, so allowing for that as well:-

=IFERROR(LOOKUP(H2,{0,2.5,3.5},{"CRITICAL","MODERATE","ACCEPTABLE"})&IF(G2<95%," wAR",""),"ERROR")

 

[NGB82KS]

Should it be >=95% or <=95%? Only one can be equal, not both. Assuming that it should be >=95% or <95% this should work.

=LOOKUP(H2,{0,2.5,3.5},{"CRITICAL","MODERATE","ACCEPTABLE"})&IF(G2<95%," wAR","")

I copied the formula and put it in, but my first line is 97% and 7.13 and its showing "Acceptable" which isn't right, i swapped the crit and accept

In that case, the formula that I suggested should work, although I did miss the part for blanks in your attempted formula, so allowing for that as well:-

=IFERROR(LOOKUP(H2,{0,2.5,3.5},{"CRITICAL","MODERATE","ACCEPTABLE"})&IF(G2<95%," wAR",""),"ERROR")

That was almost it, i changed it to the following to show an error if its blank, this is awesome thank you soooo much!

=IF(ISBLANK(H:H),"ERROR",(LOOKUP(H:H,{0,2.5,3.5},{"ACCEPTABLE","MODERATE","CRITICAL"})&IF(G:G<95%," wAR","")))