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