Hi all,
I have a data set that I would like to replace 0's with <1. However, this column includes numbers like 10, 20, 30, etc. so the replace formula is changing 10 to 1<1. Is there a formula that will look for isolated 0's?
Replace([Runway in years], "0", "<1")