Quick formula for "If, Then"

[GMC The Macro Man]

Hi team
What would be the best way to write this formula
In C2 I want to ask....
If A2 is BLANK then STOP, IF A2 >=75 AND B2="Pass", then PROMOTED, else ""
I have been fooling about with this for hours and I cannot get it
Thanks as always

 

[etaf]

=IF( A2="","Stop", IF( AND( B2="PASS",A2 >=75),"promoted", ""))

 

[Muhammad_Usman]

 

[GMC The Macro Man]

Hi Wayne
Many thanks for your reply, which was the same way I was trying to do it, so at least it made me feel I wasn't being stupid.
I found the reason why it would not work. In Col A, its a formula that returns the Test Result in a PERCENTAGE format so in the image above, A3 should actually read 70% and its the % symbol that I should be entering in the formula. I was just entering the number
=IF( A2="","Stop", IF( AND( B2="PASS",A2 >=70%),"promoted", ""))

Every day is a school day eh
Thanks again Wayne

 

[etaf]

you are welcome

 

[GMC The Macro Man]

View attachment 97594

Thanks Muhammad,
If you look at my reply to etaf you will see I should have been adding the %symbol in my formuka as that is how is is actually displayed in my data table