Systematic error message for the formula... : Excel 2016
JUNoL
Posted messages
5
Status
Member
-
JUNoL Posted messages 5 Status Member -
JUNoL Posted messages 5 Status Member -
Can someone help me solve the following problem?
Here, Excel 2016 does not want to execute the division in the following complete formula:
(PA*(1+i)^t) – PA / K*t
Yet, I am indeed in the "12 Number" tab.
I get the following answer: 21,170.61567; the correct answer is: 0.03
To obtain the correct result, in cell A, I must separately ask to execute only the numerator which is (PA*(1+i)^t) – PA = 3,820.048821
Then, in another cell B, ask to execute the denominator which is K*t = 140,000
Finally, in a third cell C, perform the division A / B to obtain the correct answer of 0.03
Thank you in advance.
(PA*( 1+i )^t) – PA / K*t = 21,170.61567 Correct answer
K 35,000 Km = 0.03
PA 17,352.55 Purchase Price (PA*( 1+i )^t) - PA = 3,820.0488 Correct answer
t 4 Years of use K*t = 140,000 Correct answer
i 0.051 5.1% Interest / year
Thank you very much for your response, but it did not solve my problem.
No matter how I write the formula:
(((1+i)^t)*PA)-PA / K*t or (((1+i)^t)*PA)-PA)/K*t or even (((1+i)^t)*PA)-PA)/(K*t); whether I add or subtract parentheses, the following error message always appears (asking me to show the formula instead of calculating):
We encountered an error in the formula.
Are you typing a formula?
When the first character is a sign (=) or less (-), Excel considers it a formula:
To solve this problem, type a ( ' ) at the front:
However, if I only do the numerator: =(((1+B4)^B3)*B2)-B2 which is equivalent to (((1+i)^t)*PA)-PA, the answer is correct.
If I add the parentheses =(((1+B4)^B3)*B2)-B2) then /K*t or even (K*t) with parentheses, I still get the same error message…???
If Excel performs the calculation, the answer is incorrect anyway.
I am therefore forced to execute the numerator, then the denominator, and then only the division of the numerator by the denominator.
In summary, no matter the parentheses or the order in which I execute the formula, I always receive the same message.
I therefore think it is another problem than just writing the formula correctly.
It may be a software-related issue!!!???
Can you shed some light on this?
Thank you very much in advance.
Here, Excel 2016 does not want to execute the division in the following complete formula:
(PA*(1+i)^t) – PA / K*t
Yet, I am indeed in the "12 Number" tab.
I get the following answer: 21,170.61567; the correct answer is: 0.03
To obtain the correct result, in cell A, I must separately ask to execute only the numerator which is (PA*(1+i)^t) – PA = 3,820.048821
Then, in another cell B, ask to execute the denominator which is K*t = 140,000
Finally, in a third cell C, perform the division A / B to obtain the correct answer of 0.03
Thank you in advance.
(PA*( 1+i )^t) – PA / K*t = 21,170.61567 Correct answer
K 35,000 Km = 0.03
PA 17,352.55 Purchase Price (PA*( 1+i )^t) - PA = 3,820.0488 Correct answer
t 4 Years of use K*t = 140,000 Correct answer
i 0.051 5.1% Interest / year
Thank you very much for your response, but it did not solve my problem.
No matter how I write the formula:
(((1+i)^t)*PA)-PA / K*t or (((1+i)^t)*PA)-PA)/K*t or even (((1+i)^t)*PA)-PA)/(K*t); whether I add or subtract parentheses, the following error message always appears (asking me to show the formula instead of calculating):
We encountered an error in the formula.
Are you typing a formula?
When the first character is a sign (=) or less (-), Excel considers it a formula:
- you type: = 1 + 1, the cell displays 2
To solve this problem, type a ( ' ) at the front:
- you type: '= 1 + 1, the cell displays: = 1 + 1
However, if I only do the numerator: =(((1+B4)^B3)*B2)-B2 which is equivalent to (((1+i)^t)*PA)-PA, the answer is correct.
If I add the parentheses =(((1+B4)^B3)*B2)-B2) then /K*t or even (K*t) with parentheses, I still get the same error message…???
If Excel performs the calculation, the answer is incorrect anyway.
I am therefore forced to execute the numerator, then the denominator, and then only the division of the numerator by the denominator.
In summary, no matter the parentheses or the order in which I execute the formula, I always receive the same message.
I therefore think it is another problem than just writing the formula correctly.
It may be a software-related issue!!!???
Can you shed some light on this?
Thank you very much in advance.
Curiously, I just tried and it works even though it previously always displayed an error message with the same way of encoding the formula. While before, I tried all the possibilities with or without parentheses, etc.
I don’t understand anything, but I’m very happy to see that this time it’s okay.
Thanks again and have a good day.