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, Sep 21, 09:37:01