# Decimal Data type (15 decimal)

Occasional Visitor

# Decimal Data type (15 decimal)

Hi all respectable members,

I am having an issue while calculating some values in Microsoft Excel.

I've an equation where result is more than 15 decimals. In such cases, Excel is not showing the decimals after 15 decimals. I've come to know that its the normal behaviour of Excel.

However, I am looking that what logic is used by Excel (i.e Truncate, Round, RoundUp or RoundDown) after the 15 decimals.

For better explanation of the issue, I am posting some values :-

Example 1

Excel = 5.8/1200 + 1 = 1.00483333333333000000

Scientific Calculator = 5.8/1200 + 1 = 1.0048333333333333333333333333333

In above, it seems that Excel is Truncating the values

Example 2

Excel = (5.8/1200 + 1) ^ -1         = 0.9951899154088570

Calculator = (5.8/1200 + 1) ^ -1 = 0.99518991540885719024713882899323

In above it seems that excel is Truncating values after 15 decimals.

Here the difference is also due to the difference result of (5.8/1200+1) ^ -1 in Excel and calculator.

Example 3

Excel = (5.8/1200 + 1) ^ -2         = 0.9904029677314890

Calculator = (5.8/1200 + 1) ^ -2 = 0.99040296773148832998554204245467

In above, it seems that excel is Rounding Up, instead of Truncating.

Bottom Line:-

I am looking forward a logic which I can use in Calculator or in My code, which helps to give results identical to Excel.

i.e.

Step 1 : First changing the values of 5.8/1200 + 1, which gives result identical to the Excel

Step 2 : Then changing the values of (5.8/1200 + 1) ^ any number, gives identical result to Excel.