IF Statement driving me insane

[tozey]

Hi guys.

Need some help with an If Statement if you please.

=IF(W7="Fail",IF(W8="Pass","A",IF(W7="Fail",IF(W8="Fail","R",IF(W8="",IF(W7="Pass","G"))))))

W7 and W8 are combo boxes (Blank, Pass, Fail)

By selecting W7 Fail and W8 Pass, it returns A
By selecting W7 Fail and W8 Fail, it returns R
By selecting W7 Pass and leaving W8 empty, it returns FALSE, I need it to return G

I am sure this is something silly that I am doing wrong, I just cannot find a solution.

Any help appreciated.

Cheers

tozey

 

[FormR]

Hi, welcome to the board!

What do you want to return when none of the criteria are met? This returns blanks.

=IF(W7="Fail",IF(W8="Pass","A",IF(W8="Fail","R","")),IF(AND(W7="Pass",W8=""),"G",""))

 

[tozey]

Thanks for the warm welcome and thank you for the solution. Yes blanks are fine should the criteria not be met.

I shall familiarise myself with the solution, thank you so much.

Alex