The way you have written your logic above is prettmuch as you will need to create an Excel IF statement.
IF(Test Condition ,This if test = true, Otherwise this if test = false)
Look at the If statement answer I gave you earlier and you should be able to work it out for yourself.
Give it a try.
Come back if you struggle.