Excel pensheads

Is there a way to do an IF formula with three possible outcomes? (ie IF x=x return 3, if x=y return 2, and if x=z return 0)

We have a rugby world cup sweep going on, and you get a different amount of points for predicting certain parameters in each game.

Yes I should have done this before setting the sweep up, but any help appreciated.

Posted By: caley canary on September 21st 2015 at 09:37:01


Message Thread


Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.

Log in