Please help on Calculation using excel

usui

Board Regular
Joined
Apr 20, 2020
Messages
55
Office Version
  1. 2016
  2. 2013
Platform
  1. Windows
Hi Excel Masters,


I would like to ask help on how to calculate this in excel, there two scenarios:

Problem #1:
864434038623597 + 2833349361FC = (answer)getting error here

then (answer) * 11 = (answer #2)

then (answer #2) must be calculated using NCK to get the 11 digit answer. please help!

Problem #2:

864434038623597 + 2833349361 = (answer)getting error here

then (answer) * 11 = (answer #2)

then (answer #2) must be calculated using NCK to get the 11 digit answer. please help!


Please help me solve this and if possible can you guide me how you solve this to get the 11 digit answer
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Problem #1:
In 3rd line you write 2833349361FC and excel define it as text (because letters) not Number.
Problem #2:
Are you write :
Excel Formula:
= 864434038623597 + 2833349361
Excel Formula:
= (ans) *11
 
Upvote 0
Problem #1:
In 3rd line you write 2833349361FC and excel define it as text (because letters) not Number.
Problem #2:
Are you write :
Excel Formula:
= 864434038623597 + 2833349361
Excel Formula:
= (ans) *11
are you able to get the 11 digit after calculating to nck?
 
Upvote 0
what you want to do with NCK exactly? Describe with detail.
 
Upvote 0

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

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