It's been a few years since I did any serious work with formulas and I'd appreciate a bit of help with the attached worksheet please.
Hopefully it's clear from the examples given in the section on the right. On entering Number in C13 I want to see a result that shows the folder and position in the form 'Folder,Position'.
It's clearly a matter of first calculating Folder by testing Number against the respective folder sizes. Then, probably using the function MOD(number,divisor), calculating Position. And finally separating the two by a comma.
I've been floundering for an hour or two but not got beyond an initial IF. Am I expecting too much from formulas and might instead need a macro?
Bookmarks