blank column condition
 

Office 2k

Spreadsheet is for our local historical society bank account.
Column c="expenses", e="deposits" and g="running balance". The first g
column(g-3) is a carryover from previous year.

What was done in past was the formula G11-C12+E12, etc.,etc. was in all
cells in column G. Problem was the total was carried all the way down the
sheet which looks bad. One sheet per year with ~ 65 entries. Don't write
that many checks or have many deposits. :)

What I'm trying to do is have the running balance columns blank unless
something is in either expense or deposit column. Then it should add/subract
value from cell above.
Here's example of what I'm trying to do but this formula isn't working
correctly. It's leaving a #VALUE! in the cell.
=IF(C12="",IF(E12-"",G11-C12+E12))

Suggestions please,

blank column condition
 

You could try something like:

=IF(AND(C12="",E12=""),"",G11-C12+E12)

HTH
Elkar


"L.S." wrote:

Office 2k

Spreadsheet is for our local historical society bank account.
Column c="expenses", e="deposits" and g="running balance". The first g
column(g-3) is a carryover from previous year.

What was done in past was the formula G11-C12+E12, etc.,etc. was in all
cells in column G. Problem was the total was carried all the way down the
sheet which looks bad. One sheet per year with ~ 65 entries. Don't write
that many checks or have many deposits. :)

What I'm trying to do is have the running balance columns blank unless
something is in either expense or deposit column. Then it should add/subract
value from cell above.
Here's example of what I'm trying to do but this formula isn't working
correctly. It's leaving a #VALUE! in the cell.
=IF(C12="",IF(E12-"",G11-C12+E12))

Suggestions please,

blank column condition
 

That did it, thanks.
Any idea what I was doing wrong or why mine didn't work?

I couldn't find anything in help with your way of doing it.


"Elkar" wrote in message
...
You could try something like:

=IF(AND(C12="",E12=""),"",G11-C12+E12)

HTH
Elkar


"L.S." wrote:

Office 2k

Spreadsheet is for our local historical society bank account.
Column c="expenses", e="deposits" and g="running balance". The first g
column(g-3) is a carryover from previous year.

What was done in past was the formula G11-C12+E12, etc.,etc. was in all
cells in column G. Problem was the total was carried all the way down the
sheet which looks bad. One sheet per year with ~ 65 entries. Don't write
that many checks or have many deposits. :)

What I'm trying to do is have the running balance columns blank unless
something is in either expense or deposit column. Then it should
add/subract
value from cell above.
Here's example of what I'm trying to do but this formula isn't working
correctly. It's leaving a #VALUE! in the cell.
=IF(C12="",IF(E12-"",G11-C12+E12))

Suggestions please,

blank column condition
 

Yours didn't work because you have a minus sign after E12; it should be an
equal sign. Also, you don't specify what to do when the condition is False.

Regards,
Fred.

"L.S." wrote in message
...
That did it, thanks.
Any idea what I was doing wrong or why mine didn't work?

I couldn't find anything in help with your way of doing it.


"Elkar" wrote in message
...
You could try something like:

=IF(AND(C12="",E12=""),"",G11-C12+E12)

HTH
Elkar


"L.S." wrote:

Office 2k

Spreadsheet is for our local historical society bank account.
Column c="expenses", e="deposits" and g="running balance". The first g
column(g-3) is a carryover from previous year.

What was done in past was the formula G11-C12+E12, etc.,etc. was in all
cells in column G. Problem was the total was carried all the way down
the
sheet which looks bad. One sheet per year with ~ 65 entries. Don't write
that many checks or have many deposits. :)

What I'm trying to do is have the running balance columns blank unless
something is in either expense or deposit column. Then it should
add/subract
value from cell above.
Here's example of what I'm trying to do but this formula isn't working
correctly. It's leaving a #VALUE! in the cell.
=IF(C12="",IF(E12-"",G11-C12+E12))

Suggestions please,

blank column condition
 

Thanks, missed the "-" sign and will work on the fomula.
Like the way Elkar did it but trying to learn.


"Fred Smith" wrote in message
...
Yours didn't work because you have a minus sign after E12; it should be an
equal sign. Also, you don't specify what to do when the condition is
False.

Regards,
Fred.

"L.S." wrote in message
...
That did it, thanks.
Any idea what I was doing wrong or why mine didn't work?

I couldn't find anything in help with your way of doing it.


"Elkar" wrote in message
...
You could try something like:

=IF(AND(C12="",E12=""),"",G11-C12+E12)

HTH
Elkar


"L.S." wrote:

Office 2k

Spreadsheet is for our local historical society bank account.
Column c="expenses", e="deposits" and g="running balance". The first g
column(g-3) is a carryover from previous year.

What was done in past was the formula G11-C12+E12, etc.,etc. was in all
cells in column G. Problem was the total was carried all the way down
the
sheet which looks bad. One sheet per year with ~ 65 entries. Don't
write
that many checks or have many deposits. :)

What I'm trying to do is have the running balance columns blank unless
something is in either expense or deposit column. Then it should
add/subract
value from cell above.
Here's example of what I'm trying to do but this formula isn't working
correctly. It's leaving a #VALUE! in the cell.
=IF(C12="",IF(E12-"",G11-C12+E12))

Suggestions please,