Recent content by IrinaK.

Ray, thank you very much for your help. The only thing: I do understand the process very very well (and have tons of experience, and I good at constructing excel annuity tables), the only issue I am struggling with sometimes is math. So, I am doing my best to revive my basic math as well as math...

you see, this video shows truly basic macro, and these steps work in any Excel except for my one on Mac. Shall I do something differently to make sure it works on my one too? I am not talking about profound issues; I just need to record the same thing shown in the video.

Thank you very much for your help. Could you, please, suggest which formula would be a correct one for solving this problem manually?

Homework Statement Hello! There is a function in Excel NPER which gives the number of periods/years. Here is the data: Present Value = 7 500 Annual rate 18% Number of periods per year 12 Period rate 0.18/12=0.015 Monthly payment -125 Task to find number of years to pay-off loan with minimum...

thank you, but I am sorry, I do not understand you. did you have a chance to check the part of video I am talking about?

I am not sure I am that technically informed. I presume I did write the macro from scratch, just as it is shown in the video attached. The result, well no result actually. I've tried it many many times by creating different tables.

Homework Statement Hello! I would be grateful for your help. I've tried many many times to record a mixed reference macro on my mac, and it doesn't record a thing. No problems with recording separate macros with relative or absolute reference. Problems description: I have few sheets with...

Siron, I assume that v1, v2, v3 are for vector V (first one in my example) and vector W is the second one. I didn't think that it is important to state that :)

Hello! Christina, thank you for this thread. I also have the same issue. I like Serena, I would be grateful for your further help. If given vectors are (1,2,3) and (3,6,9) that have v3 = v1+v2, does it mean that the whole V vector or W vector lies only on XOY plane (two dimensional) and OZ is...

Dear RUber, thank you very much for your detailed answers and your examples! These are very helpful! Thank you!

Homework Statement Hello! Revising geometric series, I have understood that I have the following issue - I have read again about these series and, please, take a look at what I have gotten as a result (picture attached). If I calculate a future cash flow, that is I take, for example, a = 0,5...

simple as it is! :) Thank you so much! Right! kindergarten issue - sometimes it happens :) Please, take a look at the following: 1) in case 80 000 is 100%, then 80 000 less 13% is 0.87 of 80 000 and equals 69 600 to "restore" back to 80 000 we have to multiply 69 600 by 1.1494 which is...

no no - no problems with economics, but a huge one with basic math ;)

I've tried to delete this particular massage to repost it as a new thread because it refers to a bit different topic, but couldn't, so I have deleted the text

thank you, yes, it's true, I understand this with the use of these formulas, but I don't understand the reason