I'm trying to create a calculator in excel and I'm having trouble rounding the value in between my text.
I'm trying to get the number that is next to "Number of shares required to buy 1 stock with dividend payout"
The number I get in that cell gives me a decimal, so I removed the decimals.
The formulas I have for Cost to buy and Predicted Monthly Income from are:
="Cost to buy " & E15 & " shares today"
="Predicted Monthly Income from " & E15 & " Shares"
I'm trying to get the number that is next to "Number of shares required to buy 1 stock with dividend payout"
The number I get in that cell gives me a decimal, so I removed the decimals.
The formulas I have for Cost to buy and Predicted Monthly Income from are:
="Cost to buy " & E15 & " shares today"
="Predicted Monthly Income from " & E15 & " Shares"