IF + IF?
Hi
Try
=IF(A6="Cons",1+(B6=0.7)+(B6=0.8)+(B6=0.85)+(B6 =0.9),
IF(A6="Prem",1+(B6=0.75)+(B6=0.83)+(B6=0.86)+(B 6=0.91),""))
--
Regards
Roger Govier
"JLatham" HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
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(B60.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(B60.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(B670%,1,"")))))
and
IF A6="Prem" then =IF(B6=91%, 5, IF(B6=86%,4, IF(B6=83%,3,
IF(B6=75%,2,
IF(B675%,1,""))))).
|