Formula Calculation Method (IF)

[SH_94]

Dear Community,

Currently i plan to write the formula for the following table:

The formula i plan to write as below:

If Method=Multiply, then Amount 1 *Rate

Else Amount 1/Rate

May i know if there is any better idea or could anyone please enlighten me if the formula that i put is correct?

Many thanks in advance.

[JosephSerpis · Accepted solution]

Hi @SH_94 your arguments in your formula are correct the syntax does need altering. You need to wrap Multiply in quotes because it's text, the coma after multiply is not needed. Your columns need Square brackets and lastly you need Endif at the end. 

If [Method]="Multiply" then [Amount 1] *[Rate]

Else [Amount 1]/[Rate]

Endif

[DawnDuong · Accepted solution]

HI @SH_94 

When i was new to Alteryx, one trick I used to avoid syntax error when using IF statement is to type the "blank" formula first, like below:

IF

THEN

ELSE

ENDIF

Then I'll fill in the evaluation / outcome expression. This is to avoid the oft-encountered syntax error of inserting comma "," which Excel users (like myself) often make at the beginning.

Highly recommend that you watch the interactive lessons "For Excel Users" too.

Cheers,

Dawn.

[SH_94]

Hi @JosephSerpis ,

Thanks a lot for the guidance and sharing on how to write the IF formula.

Appreciate it a lot.