Forum home » Delegate support and help forum » Microsoft Excel Training and help » Introduction to Excel
Introduction to Excel
Resolved · Low Priority · Version 2003
Introduction to Excel
when you have taken out the decimal point does the figure round up and round downFor upcoming training course dates see: Pricing & availability
RE: Introduction to Excel
Hi Ann,Thank you for your question.
When you decrease the number of decimal places to zero, if the answer was 0.654, then Excel would round the figure up to 1 as the number after the decimal is 5 or above.
However if the answer was 0.45 then Excel would round that down to 0.
So even though 0 is displayed that actual answer is 0.4.
I hope this answers your question.
Regards
Simon
|
|
» Forum post: Inherited documents |



Course updates

