Hi, I need help with a complicated formula, and do not mind doing it in a few separated steps if needs to.
I need to perform the following;
IF "value is in the form of 0.xx, ROUND UP to the nearest 0.1 decimal place", ELSE "ROUND to the nearest 1.00"
Then convert to TEXT.
Anyone can help?
Thanks.
Bookmarks