I’ve searched all the tech forums and I can’t seem to find the answer to this.
Are any of you excel experts/masters? So this is my issue:
In Cell F4 I have a value of 195. The formula in F4 is =CEILING(B5*D4, 5). The formula is taking 300 and taking 65% of it which is 195. So with the way I currently have it setup it’s multiplying b5 by d4 and its rounding up to the closest 5.
I have a list of numbers in P1-P14 in descending order. The numbers are 405, 385, 365, 335, 315, 295, 275, 245, 225, 205, 185, 155, 135, 115, 95.
What I need to be able to do is instead of F4 rounding up to the closest 5, I need it to round to the closet number in this list.
What formula can I write to make this happen?
If you want to know what I’m doing, I am creating my 5/3/1 spreadsheet. I have it fully functional. But the thing is I only want to use 45’s, 25’s, 10’s when training. So instead of using the exact number how it currently displayed, I want it to round up the closest number (up or down) to the list. So for example my particular says 195. It would round up to 205 or round down to 185 depending on what it actually rounds to.
Let me know if I need to explain this a bit better. Thanks!