Nested IF / AND statements excel 2010

**cossie2k** · 06-12-2012, 08:20 AM

Hi Everyone,

I have writen this formula:-
=IF(AND(G32="Random",H32="Operator"),"0.9"),IF(AND(G32="Random",H32="Inspector"),"0.1","1")

In column G I have either "Random", "Mandatory" or its blank
In column H I have either "Operator", "inspector" or its blank

What I am trying to do is:-

When "Random" and "Operator" then write "0.9"
When "Random" and "Inspector" then write "0.1"
For all other scenarios I would like "1"

Can anyone point me in the right direction?

Thanks
Alex

**benishiryo** · 06-12-2012, 08:26 AM

hi Alex, almost there~
=IF(AND(G32="Random",H32="Operator"),0.9,IF(AND(G32="Random",H32="Inspector"),0.1,1))

you dont need the results as text, do you? if you do, then wrap with quotes like this:
=IF(AND(G32="Random",H32="Operator"),"0.9",IF(AND(G32="Random",H32="Inspector"),"0.1","1"))