I need a formula that will look at all the data in a specific row and will:
1) Round decimal values up to the nearest 5 AND add a FT suffix (10.2354 becomes 15 FT)
2) Leaves whole numbers unchanged
Example data set attached.
I'm sure this is pretty simple, but everything i can think of converts the whole #s also.
Thanks,
Bookmarks