Replace Null with Data- If Statement Formula

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.

Reinbursement WF.yxmd

Expected Results 8.5.2025.xlsx

Input

Output

Preparation

Accepted answers

davidskaife

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

All comments

davidskaife

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

Reinbursement WF.yxzp

Lizbhernan

Thank you @davidskaife appreciate your help 😊

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335