Replace Null with Data- If Statement Formula

[Lizbhernan]

Hello, I am working on a workflow in which some of my data is in another column so I am trying to bring it together into an updated column. I tried using an If statement formula to bring over data into null columns but when I try it, it makes the rest of the data null instead of combining both columns data. 

This is my formula IF [ Reimbursement Rate with Tax ]=Null() THEN [Reimbursement Rate with Tax10]ELSE Null() ENDIF

I have attached a sample and my desired results.

Any help with this would be greatly appreciated.

[davidskaife · Accepted solution]

Hi @Lizbhernan 

You weren't too far off - try this instead

IF isnull([ Reimbursement Rate with Tax ]) 
THEN [Reimbursement Rate with Tax10]
ELSE [ Reimbursement Rate with Tax ] 
ENDIF

[binu_acs]

@Lizbhernan updated the workflow

[Lizbhernan]

Thank you @davidskaife appreciate your help 😊