Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-10-2010, 06:09 AM
markg2 markg2 is offline Formula problem? Windows 7 Formula problem? Office 2007
Expert
Formula problem?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

A couple of clarifications Kimberly...



If the limit is 15 digits regardless of the decimal, then the spreadsheet couldn't calculate 100 trillion?

There's no difference between round(2) and Round as shown (assuming the as shown cells have been set to 2 decimals) correct? I will not be using either of the conventions--my wife will for a specific group of folks. This group does not generally use spreadsheets--they use a calculator. This effort is to avoid conflicts wherein her spreadsheet values do not align with those of an ordinary calculator.

I'm very interested in this discussion since I never realized this stuff before and I'm sure this new knowledge, once I understand it better, will help me in the future.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
excel help Formula sellspeed Excel 15 03-10-2010 10:57 AM
Formula problem? Help with Formula Corca Excel 6 02-22-2010 09:40 PM
Formula problem? If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
Formula problem? Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:32 AM.


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