Application of 2 conditions in if statement for same column

[Gsiva3]

Hi Team,

Please help me on this.

I have a input with values like blank cells, A, D, C. By required output is If values is = "" or "A" then output should be "" blank, else output should be 99+cell values.

Input	Output
A
B	99B
C	99C
D	99D
A
A
D	99D

[DawnDuong]

I think this should work for you:

IF [Input] = "" OR [Input] = "A"

THEN ""

ELSE "99"+[Input]
ENDIF

If you have not already done so, highly recommend that you watch the interactive lessons. The "Alteryx for Excel Users" is particularly useful.

[Gsiva3]

Hi @DawnDuong 

I have already tried this formula. But is not working out.

Please see the screen shot below.

[DawnDuong]

You need to Update column "Output" or create a new column called "Output" if that does not already exist.

Currently you set to update "Input"... Also you can use Isnull() function to capture both blank and null inputs.

Formula tool is really a core tool, really recommend that you learn the basics via that 5-min interactive lesson.

Cheers.