Have a form that I've created that has 99% of the fields calculating just fine (mainly because they are all sums of othe fields)... HOWEVER. I need to caluclate the yearly monthly expenses of someones mortgage.
IE: After inputting all the info in the current monthly expense fields, that auto sums in the "total payments" box. I need to then calculate what the yearly mortgage expense is. So "total payments*12"
I have NEVER programed anything in Java and aren't sure I want to learn for three calculations that I need help on... but I'm willing to give it a try.
Besides doing that for three different 'cells', I also need to calculate the monthly savings of the 'before' payment compared to the 'after' payment.
So it would be "total current monthly expenses - proposed monthly expenses"... and that's it really.
Not sure where to start, if I'm supposed to literally spell out the tooltips in the field for the advanced calculations, which is why I'm here.
I'm new to the forum, but seems you guys have a LOT of good info and I apologize LONG in advance if there is a thread on this. I did a search, but to be honest, I can't find something that applies exactly to what I'm asking about and can't sit in my office searching a forum (that has to wait until I get home).
Thanks guys.
George Kaiser