Calculator and Excel show different result

S

SeasideColors

New Member
Joined
May 13, 2016
Messages
1
Hello everybody,

How is it that this equation, correctly counted in Excel,

300*(1/0,005-1/(0,005*1,005^48))=12 774,10

gives me over and over again 42,58 counted with a calculator?

Any help will be appreciated. Thanks.
 
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Solved
sum a quarter of data but change calc mid quarter
Replies
3
Views
86
Sam_D_Ben
Sam_D_Ben
M
  • Question Question
Slope equation value when empty cells are included
Replies
5
Views
131
mvillasana
M
P
  • Question Question
Empty table row count
Replies
2
Views
121
Peter_SSs
Peter_SSs
J
  • Question Question
Calculated Date Time field with 12 AM not recognized as 0
Replies
3
Views
159
KillerOfGiants
K
V
  • Question Question
Disallowing user to change cell color
Replies
5
Views
222
Logit
Logit

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top