|
|
#2
10-04-2024, 05:31 AM
|
||||
|
||||
You are the " victim " of floating point error. The ROUND function will help you out. More info at Floating-point arithmetic may give inaccurate result in Excel - Microsoft 365 Apps | Microsoft Learn
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Link (to Excel cell) Field Date Formatting Showing Incorrect Year | eyefuel | Word | 2 | 06-15-2023 12:32 PM |
| Slow response updating cell values & calculated cells XL2013 | kdash | Excel | 1 | 05-06-2015 10:05 AM |
| Find out whether a cell has been typed or calculated | C J Squibb | Excel | 1 | 10-01-2013 11:41 AM |
 Inserting a date calculated from a table cell
|
theMikeD | Word | 2 | 09-11-2012 05:46 PM |
|
Calculated dates.
|
Ziggy-R | Word | 10 | 09-28-2010 01:42 AM |
Windows 10 
Office 2021
Threaded Mode