Help with bank account formula

can you post an example spreadsheet - the image is difficult to see

with explanation of outcome required and cells involved

Goals.xlsx

This is the acctual spreadsheet, i hope it helps better then the image

thank you

no idea what happened to the format - but I copied into a new sheet and seems to have worked the values

so now the formulas are working - what do you need to do - be specific as possible

Originally Posted by etaf

no idea what happened to the format - but I copied into a new sheet and seems to have worked the values

so now the formulas are working - what do you need to do - be specific as possible

Ok, what i want to do since the if function for the bank doesn't allow me to use the previous one if no value is added, is be able to update and preview a future bank balance based on the next months income plus the previous month income. Does it make any sense?

So, lets say i have nothing on the bank cell for the month of april, but starting on the month of may, i want the sheet to calculate my future balance based on the month of april (which would be the amount in cell b1), plus the "remaining" cell of the month of may, and so on until you reach the month of december.

sorry , i dont follow

that appears to be what you have

in cell C17 its blank ?

column 15, then from column 16

do you mean ROW ?

if you are getting
#value
then you can use
IFERROR or ISERROR to manage those errors
http://office.microsoft.com/en-gb/ex...001231765.aspx
http://www.techonthenet.com/excel/formulas/iserror.php

if you use $B$1 that will fix the cell and so you can copy formulas without that reference changing
c17=($b$1+c15)

IFERROR(($b$1+c15),"")

Originally Posted by etaf

that appears to be what you have

in cell C17 its blank ?

do you mean ROW ?

if you are getting
#value
then you can use
IFERROR or ISERROR to manage those errors
http://office.microsoft.com/en-gb/ex...001231765.aspx
http://www.techonthenet.com/excel/formulas/iserror.php

if you use $B$1 that will fix the cell and so you can copy formulas without that reference changing
c17=($b$1+c15)

IFERROR(($b$1+c15),"")

Right, cell c17 it's showing blank because of the IF function, if i remove that and there is no values above it, it will return with $0.00, which i do not want.
And i meant column C and column D, i corrected my error there, sorry.

do not use the + sign in the sum - that will give errors

use
=SUM(B1,C15)

then you will get B1 value , even if C15 is blank - is that what you wanted

Originally Posted by etaf

do not use the + sign in the sum - that will give errors

use
=SUM(B1,C15)

then you will get B1 value , even if C15 is blank - is that what you wanted

Ok, i did this new sheet based on what i want, this is how i had it when i began.
what i want this spreadsheet to do now is not show the values $0.00 when nothing is inserted.

i was able to do it before using the function IF, but it messed up the rest of the formulas, so now i came back to what i had to see if someone can find a easier way to fix this problem.

it seems like such an easy solution, but i can't get my head around it.

thanks.

i have used a combination of
=Sum(cell,cell)

where numbers subtract, i have used
iferror(calc),"")

and for ranges addition , i have used
if(cell=0, "", calc)

see attached

Originally Posted by etaf

i have used a combination of
=Sum(cell,cell)

where numbers subtract, i have used
iferror(calc),"")

and for ranges addition , i have used
if(cell=0, "", calc)

see attached

I don't know if in yours it kept showing #name? But it is showing on mine and the formulas are not doing what they were supposed to. They are not working anymore. I appreciate the help, can you think of something else?

Thank you.

can you show the spreadsheet - you would need to replace the cells and calc with the actual values

I don't know if in yours it kept showing #name?

did you look at the attached spreadsheet and the formulas I used throughout , and you will see they all worked OK without #name error

if you just want all zeros to NOT be displayed
there is an option in excel to do that

goto options
Advanced

look for

Show a Zero in cells that have a zero value

and uncheck

that will stop zeros being displayed

Originally Posted by etaf

if you just want all zeros to NOT be displayed
there is an option in excel to do that

goto options
Advanced

look for

Show a Zero in cells that have a zero value

and uncheck

that will stop zeros being displayed

Wow, was it really that simple? Thanks man. That is exactly what I was looking for.

your welcome, glad i remembered the setting...