Hi guys !
I would like to create a function which would round a number by looking first at the nearest lowest value in a range of cells. Like for instance, if i have 17.9, it would go for 15, which is the immediate lowest value in the table.
Then, it would check if 17.9 belongs to the area going from this immediate lowest number to +15% of this number.
Here, we would check if 17.9 belong to the area starting from 15 to 17.25. as it does not belong to it, we would take the immediate UPPER number (for instance 20 in the table).
It it belongs to it, we would stay with the immediate LOWER number (here 15).
Hope you can help me to manage that . I have some skills in vba, but when it is coming to create user defined functions i am a bit struggling...
Thanks a lot!
Bookmarks