IF than formula

[Jon_Taylor]

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

[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 · Accepted solution]

Hi @Jon_Taylor 

See below for the WF:

Just use the formula to create multiple IF functions.

Pedro.

[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' 🙂