Actually, you do have 2 redundant IFs, because all values of B6 are
exhausted so you dont need the condition IF(B6<0.7,1,"") under
A6="Cons" as this will never return "", and similarly for
IF(B6<0.75,1,"") if A6="Prem".

Hope this helps.

Pete

On Aug 29, 12:12*am, RoadKill
wrote:
I guess I was just missing the "")) at the end.

Thanks



"JLatham" wrote:
How about

=IF(A6="Cons",IF(B6=0.9,5,IF(B6=0.85,4,IF(B6=0. 8,3,IF(B6=0.7,2,IF(B6<0.*7,1,""))))),IF(A6="Prem" ,IF(B6=0.91,5,IF(B6=0.86,4,IF(B6=0.83,3,IF(B6= 0*.75,2,IF(B6<0.75,1,""))))),""))

"RoadKill" wrote:

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,""))))).- Hide quoted text -

- Show quoted text -