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)?

I figured it out... =ROUND((D26*D24)/10,-2)

Ask Your Question

Weekly Poll

Would you use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History