Solved How do I round the prodcut of a formula to the nearest 100?

October 17, 2017 at 09:00:04
Specs: Windows 7
I want to round the results of a formula in a cell. I'm multiplying 70 basis points, which is in cell K26 and custom formatted as 0"bps" times $85B, which is in cell K26 and custom formatted as $0"B". The formula is in cell K25 as (K26*K24)/10. I'm dividing by 10 because without that the answer comes out to $5,950, but I want to show the answer in 100s, which would be $595. My question is, how do I round the $595 up to the nearest 100 so that the answer appears as $600 (actually $600M is the format I want but I suspect the format I show above will do that)?

See More: How do I round the prodcut of a formula to the nearest 100?

Reply ↓  Report •

#1
October 17, 2017 at 10:11:50
✔ Best Answer
I figured it out... =ROUND((D26*D24)/10,-2)

Reply ↓  Report •
Related Solutions


Ask Question