Slickdeals is community-supported.  We may get paid by brands for deals, including promoted items.
5 results found matching
RSS
Filtering Options
Show results for
$ - $
Filters
Filters
Filters
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score 4 Replies 452 Views
Post #53782212 added 10-08-2012 9:32 AM by Dr. J in Archived Deals
I needed to retrofit a plot to plot every x points - there are about 3000 points distributed evenly over 60 cycles (seconds, here), and I wanted to modify an existing worksheet so that I could change...
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score 4 Replies 452 Views
Post #53783056 added 10-08-2012 10:10 AM by Jcaelum in Archived Deals
hmmmm interesting. i tried in on my computer (excel 2007, fresh sheet) and i notice the same thing. For me, it starts exactly at 4.34 going to 4.36. I am not sure why this is happening, must be one...
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score 4 Replies 452 Views
Post #53783340 added 10-08-2012 10:22 AM by menace33 in Archived Deals
I'm going to keep it simple before delving into the greater part of the spreadsheet, but have you changed for format for the cells so it reflects 2 decimal places only after the number?
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score 4 Replies 452 Views
Post #53785664 added 10-08-2012 12:08 PM by Dr. J in Archived Deals
I went in and maxxed out the decimals, which is where I found that what it displayed as 5 wasn't tried rounding, same result!
Excel is doing something strange Q....
Expired
Thread created 10-08-2012 by Dr. J
0 Score 4 Replies 452 Views
Post #53787166 added 10-08-2012 1:04 PM by Jcaelum in Archived Deals
You rounded the numbers in column A and you still get 5.00 really being 4.9999999999 ? That's weird ... i attached a screen cap of what i did. You can see that my 5.00 is truly 5.000000000000000 if...

More Results from Amazon.com See more at Amazon

More Results from Walmart.com See more at Walmart

More Results from Ebay.com

Didn't find what you were looking for?

We're displaying limited results because of the following settings:

  • Deals with Any Rating
  • Deals from Any Time
  • Deals from 26 forums
  • Deals filtered by and
  • Searching within Entire Threads

If you want to relax this search, click here to reset all search parameters. You can also adjust them by using the filtering options on the left.