Wed 10 Mar 2010, 16:31Delegate Ann said...
Ann has attended:
PowerPoint Introduction course
Excel Introduction course
Introduction to Excel
when you have taken out the decimal point does the figure round up and round down
Thu 11 Mar 2010, 10:42Trainer Simon said...
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
