Formula help if statement but want to include if blank

I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far

=IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)

Tags:

Best Answer

Answers