Samantha has attended:
Excel Advanced course
Excel Advanced course
Rounding
When using ROUND formulas, how do you type the formula for the folling scenario: Rounding down from 21.5 to 21. -1 rounds down to 20.
RE: Rounding
Hi Samantha
Sorry i haven't got back to you before now
the way for you to be doing what you are looking for would surely be the way you have displayed above as i did this myself as to the decimal places what you would need to do is decrease the places the format shows to no places
Hope this helps
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn