Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2017, 05:18 PM
cathy1 cathy1 is offline Help with this rounding formula =ROUND(M7/2,2) Windows 10 Help with this rounding formula =ROUND(M7/2,2) Office for Mac 2011
Novice
Help with this rounding formula =ROUND(M7/2,2)
 
Join Date: Jan 2017
Posts: 2
cathy1 is on a distinguished road
Default Help with this rounding formula =ROUND(M7/2,2)

Hi. I have a new job and I am not familiar with rounding formulas. Can anyone tell me what this one means?



=ROUND(M7/2,2)

Thank you!
Reply With Quote
  #2  
Old 01-22-2017, 08:32 PM
macropod's Avatar
macropod macropod is offline Help with this rounding formula =ROUND(M7/2,2) Windows 7 64bit Help with this rounding formula =ROUND(M7/2,2) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It says to dive M7 by 2 and round the result to two decimal places.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-22-2017, 08:57 PM
cathy1 cathy1 is offline Help with this rounding formula =ROUND(M7/2,2) Windows 10 Help with this rounding formula =ROUND(M7/2,2) Office for Mac 2011
Novice
Help with this rounding formula =ROUND(M7/2,2)
 
Join Date: Jan 2017
Posts: 2
cathy1 is on a distinguished road
Default

Thank you Paul!
Reply With Quote
Reply

Tags
formulas, rounding



Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom rounding up paulkaye Excel 8 09-03-2016 11:12 PM
Help with this rounding formula =ROUND(M7/2,2) Excel Seems to be Rounding Twice Rather Than Once melissapete24 Excel 5 08-27-2016 12:51 AM
Rounding to nearest 0.25 Guloluseus Excel 5 10-27-2015 11:28 PM
Rounding values inconsistent required_username Excel 10 06-05-2014 05:35 AM
Help with this rounding formula =ROUND(M7/2,2) Round off the number ubns Word VBA 4 09-06-2012 03:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft