Would someone please help me with the round. I have the following formula but I wold like it to round without creating another cell to round. How can I include round in the formula?
=M5*0.8
Thank you,
Mr Sales
Would someone please help me with the round. I have the following formula but I wold like it to round without creating another cell to round. How can I include round in the formula?
=M5*0.8
Thank you,
Mr Sales
There are a number of ways,depending if you want to round up, down to whole numbers?
=ROUND(56*0.08,0)
=ROUNDUP(56*0.08,0)
=ROUNDDOWN(56*0.08,0)
=CEILING(56*0.08,1)
=FLOOR(56*0.08,1)
=INT(56*0.08)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks