
20 Nov 2010  #1 

Excel Formula Help please...
This is probably very simple and I have got it working but it isn't working how I want it to work.
I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan is after I have made a payment, and in the third column I want to know how much the loan has been reduced by after the bank has taken interest off. I have just put this formula in the 3rd column, =SUM(D4D5), and then dragged this formula down into all the other rows I want this to work in which it does. The problem I am having with this is that the number from the 2nd column get placed in the 3rd row, below the amount that has been reduced, and I would like it to stay at £0.00 as it looks better. Here is what I mean If you notice the number I enter in the balance column appears in the reduced by column, and I don't want it too because it looks very unprofessional. Can someone please help me out with this please. 
My System Specs 
. 

20 Nov 2010  #2 

Try using IF ISBLANK.
So, the formula could be something like =IF(ISBLANK(D5),"",SUM(D4D5)) 
My System Specs 
20 Nov 2010  #3 

Thanks for that it worked a treat, now I know I am being fussy, but all the cells that had £0.00 in the rest of the spreadsheet have just gone blank. How can I get the cells to have £0.00 in them again, but keep the value from being carried? 
My System Specs 
. 

20 Nov 2010  #4 

Try this.
=IF(ISBLANK(D5),0,SUM(D4D5)) Otherwise, you could insert a string =IF(ISBLANK(D5),"£0.00",SUM(D4D5)) You may need to adjust the formatting etc. 
My System Specs 
20 Nov 2010  #5 

Once again many thanks that was very helpfull I have learned something today, just wish I could rep you more but alas I can only rep you once, if I see you around I will give you some more. 
My System Specs 
20 Nov 2010  #6 

Another possible is...
You would of course need to drag the formula down through the rest of the column. :) 
My System Specs 
20 Nov 2010  #7 


My System Specs 
Thread Tools  
Similar help and support threads  
Thread  Forum  
Excel 2016: Displaying formulas in the formula bar I am using Win 7 Pro 7601 Multiprocessor Free SP1, 64bit. Intel Core i74770, 16GB installed memory. Excel 2016. I have a spreadsheet with formulas, none of which display in the formula bar. All my other spreadsheets display their formulas in the bar. I have tried the following to display the... 
Microsoft Office  
excel formula not shown if the cells are empty i have excel file, with the following formulas Cell G2 formula =SUM(D2:F2) Cell G3 formula =SUM(G2, D3:F3) Cell G4 formula =SUM(G3, D4:F4) Cell G5 formula =SUM(G4, D5:F5) i want the result of G5 (and the rest of G cells) cells to be invisible unless there is some value in D5 to F5 cells ... 
Microsoft Office  
Excel 2013  how to keep a formula consisten Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the... 
Microsoft Office  
Excel Formula Hello Sir, Can you let me know the formula in Excel: I have a table as below: This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row 2",... 
Microsoft Office  
Excel 2003 sum formula problem I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as... 
Microsoft Office 
Our Sites 
Site Links 
About Us 
Find Us 
Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd All times are GMT 5. The time now is 18:43. 
