I'm new to the group, dont do a ton with excel for the most part and everything that I do is pretty easy normally. (FYI i did search this) not sure if i used the correct wording.
I am trying to grow my ability in excel but at this point I am stuck.
This isnt a pitch for an MLM or any sort of program. I have a compounding spreadsheet that works at $10 but I cant seem to get the decimals to carry around, SUM, and compound on the whole number. Attached are screenshots of the data done manually but I would like to be able to plug in my info into the quantity field that feeds D8.
If this is better suited for "commercial services" please let me know. I much rather not shell out a ton of cash on this.
Thank you in advance.
A (BORDER)
B TERM
C DATE
D INVESTMENT AMOUNT
E (*)
F 140%
G (=)
H D*F
I (BORDER)
J =IF(N8>0,N8+H9+X8-P8,H9+J8-P8+X8)
TERM "1" IS ROW 8
xls ask for help.JPG
Bookmarks