-6+6*6 = 25. No, that isn't right...
November 10, 2009 3:48 PM Subscribe
Any Excel whizzes out there? I'm having a problem that I just know is going to have a head-slappingly simple solution, but I still can't figure it out.
posted by andrewcilento to computers & internet (8 answers total)
Okay, so here's the skinny:
I have an Excel spreadsheet I've been using to keep track of the various debts I owe. One of those debts is a personal loan I took out thinking that it would be a debt consolidation loan...another topic for another time. What I want to have Excel do is give me the difference of $19,268.11 (the total loan amount including interest) and x (the number of payments remaining on the loan multiplied by the amount I have to pay each month). The formula bar for that cell looks like this:
C2 is x, which at this moment is 10. The trouble is, it's not coming out right. If I do just the part to the right of the minus sign, I get 16060; so far so good. When I include 19,268.11, though, it comes out to 3208.11. What gives?
Lightning round: how would I have the difference display itself as dollars and cents rather than just a number?