If/Then and Math

I’m trying to create columnA (If/Then column) that will display a formatted number value based on a condition. The condition looks at the value in columnB (a Math column). If columnB contains a value then it returns that value in columnA. If it has no value, then columnA receives the value from columnC (another Math column). My If/Then works but it loses the number formatting. Is there a way to do this without losing the formatting?

This is a known issue. The workaround is to add another math column at the end to re-apply the desired formatting.


Brilliant! Thank you!