Trying to my own personal Cryptocurrency Converter Calculator to track my investments not sure of the formula layout?

RudeBoy

Active Member
Joined
Feb 2, 2003
Messages
376
I am trying to create a simple tracker for the price of a crypto item and if I invest $20 how many shares I will own.

Here is an example we will call it Crypto-J​

Crypto-J's current price is = 0.015684 United States Dollar "$" (USD)
According to the Cryptocurrency Converter Calculator
If I own 4000 shares of Crypto-J then it will cost me $62.73

So I guess this is more of a math question on how to create this formula? Helpppppppppppppp

So in cell D4 I have the investment price of $62.73
In Cell C4 I have the price of Crypto-J which is currently 0.015684
I am trying to figure out the EXCEL formula that will be in F4 that should be equal to 4000 Shares based on what the Cryptocurrency Converter Calculator says.
How do I figure out the formula? I tried multiplying it but that gives me = 0.972315 In F4 I used formula =D4*C4 but that is not getting me the 4000 number.

Let me know if someone has figured out this formula Thanks so much stay safe.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,214,918
Messages
6,122,257
Members
449,075
Latest member
staticfluids

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