Hey all, I'm in need of a formula that will take the highest 100 number and take the remaining and put it in another cell if possible.
For example:
A1: $660
How would I go about taking $600 putting it into cell B1 and taking $60 into B2?
Therefore, every number I put in will be rounded down to the nearest 100 without completely getting rid of the remainder of the number. Is this possible or am I asking for too much? Any help would be much appreciated!
Bookmarks