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.
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.
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.