I managed to find a way of doing it. If anyone else has the same problem in the future:

Here's where I got it from: http://www.contextures.com/xlfunctions02.html#IF