 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

I7 = BID price

F7 = entry price

D7 = profit/loss
E7 = total cost to purchase/sell divide by 100

The F7-I7 is giving the wrong result
.83 minus .50 = .33 but it is giving -.33

The answer should be when formula runs
83-50 = 33
But result shows -33

13. ##### Val

I understand if its some kind of big numbers or difficult calculations, but in my case, I’m trying to subtract 96,00-95,04 and it gives me 0,959999999999994

instead of 0,96. anyone can calculate it in their mind, 1,00 – 0,04 equals 0,96. right? But in excel it says 0,959999999999994

14. ##### Sarah Lange

I have a list of about 64 whole number in a spreadsheet. I have used the @sum to total these numbers. In a separate spreadsheet, I have reproduced this column and am coming up with a different total, a difference of 634. There are two numbers 634 in the list. I can take them out and put them back in and am still getting a wrong answer. I have finally added them on an adding machine and found that one of the answers is correct. I recreated both columns using copy and paste (columns now side by side). The numbers are identical but yield different totals. I am at a loss to figure out why this is happening.

15. ##### No Confidence

I have similar problems, but the miscalculations started only after I reached a certain amount of information and calculations on the sheet. Maybe its a memory handling problem.

If I were Micro Soft I would be very embarrassed. How could they let this out from development stage?

How can anyone have any confidence in their work. I strongly suspect it is very poor design in handling data and algorithmic stratagem on how to correctly handle floating decimal points and mantessa calculation overflow. I used an old, I mean 17, year old QuottroPro program and there is no problem.

Excel is far removed from Excellence.

16. ##### Orly

A2 B2 C3 Formula Excel Results Calculator Results
70.8 64 58.6 =A2 – B2 / C2 69.71 0.97

need help with this formula I need the calculator results to be the same with the excel results

17. ##### Gene

I have a fairly complex formula (=IF(Q171>0,0.75*Q171,IF(AND(ISFORMULA(E171),ISFORMULA(M171),ISBLANK(Q171)),0,IF(OR(ISFORMULA(E171),E171=\$S\$5),0,MAX(E171,M171)))) with E171=180 and M171 is a formula and Q171 is blank. If you click on the Function button next to the formula it say the result is 180, but it is entering 0 in the cell. Does anyone know why?

18. ##### jo

it cant help me but i do it