Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Resolved · High Priority · Version 2003
Chandni has attended:
Excel Intermediate course
Project Intro Intermediate course
If I use a formula to attain the total created in a row, how can I then adjust the total figure so that it rounds up to the nearest 10 or 100, without losing the formula or having to enter the number in manually?
Dear Chandni
Thank you for attending Excel Intermediate course. I hope you enjoyed the course and can
|
Excel tip:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |
We'll call during UK business hours
Server loaded in 0.07 secs.