Excel simple sum

Hi all,
I have three cells which I want subtracted from a 1000 to give the answer -134.28.

=(I3*C5*F5)-(1000) <== I can't get this to work and give the correct answer although it works by using a calculator

C3 = 18.82%
I3 = 10
F5 = 4.6

Any help would be gratefully received.
Dave.
IrazorAsked:
Who is Participating?
 
helpfinderConnect With a Mentor IT ConsultantCommented:
Hi,
first, in your example you calculate with C5, but afterward you present C3 (probably just mistype)
anyway, when I do the same on calculator I get -991,3428 as a result, follow me:
(0,1882*10*4,6) - 1000 = (1,882*4,6) - 1000 = 8,6572 - 1000 = -991,3428

When you are counting with your calculator, you probably count with 18,82 instead of 0,1882. Since your value is percentage is mathematicaly not correct to count with 18,82 when you calculating
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.