Replace black cells in a specific column to a default number/text

[maddoxs]

I am attempting to get these blank cells to be automatically replaced in excel as "N60". I am assuming this will be done through a formula tool after selecting the pay terms column. Could anyone assist? Thank you in advance 

[asya · Accepted solution]

Hi Maddoxs!

You're correct in assuming you can use the Formula tool. As seen in the screenshot below, I used a Formula tool with the Pay Terms column selected. I used a simple if statement to get the output necessary.