S
Sean Sydor
Hi:
I am creating a spreadsheet that will calculate monthly
data in one column while having the year-to-date results
in column beside it. How do I create a formula for the
Year-to-date amounts that will remain blank until I enter
a value into the cell beside it.
In short I want my year-to-date cells to calculate the
previous month's total plus the current month's amount
(including 0 if the total amount is 0) but remain blank if
the monthly value has not been inputed
(Currently the year-to-date values appear as 0 in all of
the months - I can eliminate this by putting an IF
statement that says [IF X>=0,X,""] The problem I have is
that the calculating cell reads a blank cell as a text,
and shows a #### if one of my values are zero. I also
tried to Format>Options>unclick Zero values, but I don't
want to do that because some of my information inputed
will be a zero)
I feel that there is a simple solution to this, but I am
pulling my hair out in frustration because I cannot find
it.
Thank you for any help.
Sean
I am creating a spreadsheet that will calculate monthly
data in one column while having the year-to-date results
in column beside it. How do I create a formula for the
Year-to-date amounts that will remain blank until I enter
a value into the cell beside it.
In short I want my year-to-date cells to calculate the
previous month's total plus the current month's amount
(including 0 if the total amount is 0) but remain blank if
the monthly value has not been inputed
(Currently the year-to-date values appear as 0 in all of
the months - I can eliminate this by putting an IF
statement that says [IF X>=0,X,""] The problem I have is
that the calculating cell reads a blank cell as a text,
and shows a #### if one of my values are zero. I also
tried to Format>Options>unclick Zero values, but I don't
want to do that because some of my information inputed
will be a zero)
I feel that there is a simple solution to this, but I am
pulling my hair out in frustration because I cannot find
it.
Thank you for any help.
Sean