IF than formula

Hi ,

I am not the best at complicated if than formula, and it may be a case for a multirow formula?

in the data below what i want to do is make a column where based on the finishing place it shows the reward. I got the first one but I am unsure how to get the other 2 lines.

Thanks,

Jon

reward example.xlsx

Expression

Accepted answers

pedrodrfaria

Hi @Jon_Taylor

See below for the WF:

Just use the formula to create multiple IF functions.

Pedro.

IF than formula.yxmd

All comments

Jon_Taylor

Also if anyone has resources to learn more about complex if than formulas and how to write them that would be great. I have watched the Alteryx learning sessions but still feel lost.

pedrodrfaria

Hi @Jon_Taylor

See below for the WF:

Just use the formula to create multiple IF functions.

Pedro.

IF than formula.yxmd

Jon_Taylor

Awesome thank you. In the formula at the end it says "elseif null() endif"

is this stating "or do nothing " end the if statement?

Also this is way easier than writing it in excel with all the confusing '()'s' 🙂

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335