Is there a way to combine the IF Statement. I will be using a similar formula
for six separate metrics so would be great if I didn't need to build a table
and do index matching.

Basically I want it to do this in my C6 cell:

IF A6="Cons" then =IF(B6=90%, 5, IF(B6=85%,4, IF(B6=80%,3, IF(B6=70%,2,
IF(B6<70%,1,"")))))

and

IF A6="Prem" then =IF(B6=91%, 5, IF(B6=86%,4, IF(B6=83%,3, IF(B6=75%,2,
IF(B6<75%,1,""))))).