SPREADSHEETS - 11.05.2022

Rounding budgeted numbers to the nearest 1,000

Using exact numbers to the nearest £1 in budgets and forecasts can make more work for you when it comes to explaining miniscule variances. There are ways in Excel to round the numbers to the nearest 100 or 1,000. How do you do it?

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed bibendum, sapien nec interdum commodo, ex elit feugiat velit, vel tincidunt nibh massa nec turpis. Phasellus rutrum pulvinar tristique. Aenean vel maximus velit. Integer in purus dictum, commodo diam sed, facilisis metus. Duis sed consequat nisi. Phasellus et risus neque. Curabitur mattis, nibh ac finibus bibendum, nulla augue commodo ipsum, vitae tristique urna felis in velit. Cras et eleifend lorem, in convallis leo. Fusce id nibh et leo congue convallis. Vivamus imperdiet ipsum sit amet felis condimentum, a lobortis felis rutrum. Integer ullamcorper, turpis in aliquet tincidunt, est tellus volutpat leo, id pretium massa nibh sed orci. Pellentesque ac viverra lacus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Ut ut ante eget nulla volutpat tempor. Donec commodo leo mi, congue blandit leo euismod ut.