 1. ##### Bill Young

I have been using Excel for roughly 20 years. I have a degree in electrical engineering so I can handle pretty much any math needed in Excel. I am doing what is known as loss development. Essentially I need to get the precise number of years between two dates. Precise, even fractionally precise. I figured Excel’s YEARFRAC function did this. It doesn’t. For example =YEARFRAC(“8/1/2011″,”7/31/2012”) and =YEARFRAC(“8/1/2011″,”8/1/2012”) both return precisely 1.00000 as the answer (absolutely identical results, verified using =(A2=B2) where the results of the YEARFRAC formulas are stored in A2 and B2). Frustrating!

2. ##### Joe

I had a different calculation problem. I was subtracting a cell that was the calculated sum of expenses from a cell that was the calculated sum of income. Excel gave me a result of \$0, even though there was a difference between income and expenses. What fixed the problem was deleting the formula in the calculated expenses cell and then re-entering it. The new formula was exactly the same, so I have no idea why Excel didn’t come up with the right answer the first time. Good thing it was an error that was easy to catch.

3. ##### MD40

This was help me to save my time. Thank you for tuto. Cheers.

4. ##### Sudhir Pani

When I am using RIGHT or LEFT formula, i am getting incorrect results.
Below is the example I am getting the error as,

Ex. in the cell A2 which has a date as 01-Jan-2018
When I am applying the formula as =RIGHT(A2,4),I should get the result as 2018, however it is showing me as 3209

I also set the formatting on date, however nothing is working for me.

Thanks

5. ##### Charyen Daymiel

This is such a big help! Thank you so much.

6. ##### Silvano Rego

This little calculation gives me an error

6356752,31424518^2

in excel = 40408299984661,50000000000000000000

in other calculators = 40408299984661,4516607531532324

How can this be possible?

Silvano

7. ##### Peter

I assume this is why I get an odd result when I add the following list of numbers (in this order). Using ‘SUM’, gives the total 5418.54. Displaying the total to 11 decimal places gives me 5418.54000000001.

However, calculating it as (27 x 87.02) + 3069 gives the result 5418.54 with no extra decimals.

Oddly though, adding the same numbers in a different order, removes the extra decimals. Using ROUND also works.

3069
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02
87.02

8. ##### Sarika

Hi…yes..simple multiplication…
111111111
x 111111111
MS Excle gives wrong answer 12345678987654300.

Check it out….and comment….

9. ##### War Consigliere

Excel even struggles with simple addition. It insists on telling me that -28.96+25+5-1+0.02-0.06 = -8.46545E-16. There shouldn’t be any rounding involved and it shouldn’t be storing more than two decimal places through the sum.

10. ##### SpacePanda

The roundup function worked for me!! Thought I was going crazy with excel giving wrong numbers!! Thank you!!

11. ##### John

Excel calculate wrong. Basic operation without roundings: 5-1(6-7). Calculus order is 1. Bracks (=-1) then> Multiply (-1-1 ==1) then subtraction 5-1 and the result is 4. Excel claim, it is 6. EXCEL DOES NOT KNOW CALCULUS ORDER

12. ##### trendfriendpa

What iswrong with this formula?

=D7*IF(OR(C7=”BC”,C7=”BP”,C7=”SC”,,C7=”SP”),(H7-F7),(F7-I7)-(E7/100))

C7 = type of purchase/sale