Here are some problems that our users have asked and received explanations on
I am creating a loan calculator to be rolled out to multiple users. Currently i am using the PMT formula to calculate the repayment amount. My issue is if the user knows the repayment amount and would like to know the repayment Period. I am struggling with having two formulas working on the same calculator depending what variables are inputted.
Solved by S. J. in 14 mins
Hi I need help with PMT and Absolute PMT problems. There are 2 sheets I will send you.
Solved by M. D. in 15 mins
I have a working excel sheet. It is a 3 vertical tab calculator where, depending on which tab is selected, will give financial summaries when data is input into 5 unlocked cells. It works great...BUT I now want to make it into an interactive web application. Is this possible?
Solved by O. B. in 26 mins
I have created a formula with true and false however would like it to be $0 if the cells are blank. =IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)