Help with formatting
 

Hello. I have created a spreadsheet with very basic formulas. Basically, the
formulas are adding down columns to create running totals. For example,
column D is amount paid, and column E is amount paid to date. I have figured
out how to hide "zero" values, but in my running total column (E) the current
total appears all the way down thousands of sheets. Is there a way to have
the running total only appear on the lines that I have filled in information
for, and not repeat the same number for thousands of rows down? Hopefully
someone can help! Thanks so much,

Jennifer in Miami

Help with formatting
 

Put this in e2 and copy down.
IF(D2,d2+e1,"")

Jennifer wrote:

Hello. I have created a spreadsheet with very basic formulas. Basically, the
formulas are adding down columns to create running totals. For example,
column D is amount paid, and column E is amount paid to date. I have figured
out how to hide "zero" values, but in my running total column (E) the current
total appears all the way down thousands of sheets. Is there a way to have
the running total only appear on the lines that I have filled in information
for, and not repeat the same number for thousands of rows down? Hopefully
someone can help! Thanks so much,

Jennifer in Miami

Help with formatting
 

I copied this formula into the spreadsheet; however, it shows "FALSE" in the
cells below the running total. Basically, I am trying to create a
spreadsheet that I can continually log into and add additional information,
and have the running total continue to update. In order to do that, I have
to format cells that do not have any information in them yet. However, once
I format them w/ the formula, then the data from the previous cells copies
down. Any suggestions on how to get rid of "FALSE"? Thanks,

"Bob I" wrote:

Put this in e2 and copy down.
IF(D2,d2+e1,"")

Jennifer wrote:

Hello. I have created a spreadsheet with very basic formulas. Basically, the
formulas are adding down columns to create running totals. For example,
column D is amount paid, and column E is amount paid to date. I have figured
out how to hide "zero" values, but in my running total column (E) the current
total appears all the way down thousands of sheets. Is there a way to have
the running total only appear on the lines that I have filled in information
for, and not repeat the same number for thousands of rows down? Hopefully
someone can help! Thanks so much,

Jennifer in Miami

Help with formatting
 

There must be something in the D column, so fix with
IF(D20,D2+E1,"")

Jennifer wrote:

I copied this formula into the spreadsheet; however, it shows "FALSE" in the
cells below the running total. Basically, I am trying to create a
spreadsheet that I can continually log into and add additional information,
and have the running total continue to update. In order to do that, I have
to format cells that do not have any information in them yet. However, once
I format them w/ the formula, then the data from the previous cells copies
down. Any suggestions on how to get rid of "FALSE"? Thanks,

"Bob I" wrote:


Put this in e2 and copy down.
IF(D2,d2+e1,"")

Jennifer wrote:


Hello. I have created a spreadsheet with very basic formulas. Basically, the
formulas are adding down columns to create running totals. For example,
column D is amount paid, and column E is amount paid to date. I have figured
out how to hide "zero" values, but in my running total column (E) the current
total appears all the way down thousands of sheets. Is there a way to have
the running total only appear on the lines that I have filled in information
for, and not repeat the same number for thousands of rows down? Hopefully
someone can help! Thanks so much,

Jennifer in Miami

Help with formatting
 

Bob I,

I understand now what you're telling me to do...and the formula works fine
for the data that I already have inputted. I want to format the specific
column for FUTURE data entry, which it won't let me do. Like you said, there
has to be something in the D column in order for the formula to work. I'm
trying to format ahead of anticipated future entries, so that when the user
logs in to input another set of data, that data is automatically calculated
and updated. Is there a way to format the E column cells in
advance...without anything being in the D column right now?

"Bob I" wrote:

There must be something in the D column, so fix with
IF(D20,D2+E1,"")

Jennifer wrote:

I copied this formula into the spreadsheet; however, it shows "FALSE" in the
cells below the running total. Basically, I am trying to create a
spreadsheet that I can continually log into and add additional information,
and have the running total continue to update. In order to do that, I have
to format cells that do not have any information in them yet. However, once
I format them w/ the formula, then the data from the previous cells copies
down. Any suggestions on how to get rid of "FALSE"? Thanks,

"Bob I" wrote:


Put this in e2 and copy down.
IF(D2,d2+e1,"")

Jennifer wrote:


Hello. I have created a spreadsheet with very basic formulas. Basically, the
formulas are adding down columns to create running totals. For example,
column D is amount paid, and column E is amount paid to date. I have figured
out how to hide "zero" values, but in my running total column (E) the current
total appears all the way down thousands of sheets. Is there a way to have
the running total only appear on the lines that I have filled in information
for, and not repeat the same number for thousands of rows down? Hopefully
someone can help! Thanks so much,

Jennifer in Miami

Help with formatting
 

Yes, see the change I made to check for greater than 0 in the D cell.
Here it again.

IF(D20,D2+E1,"")

Jennifer wrote:

Bob I,

I understand now what you're telling me to do...and the formula works fine
for the data that I already have inputted. I want to format the specific
column for FUTURE data entry, which it won't let me do. Like you said, there
has to be something in the D column in order for the formula to work. I'm
trying to format ahead of anticipated future entries, so that when the user
logs in to input another set of data, that data is automatically calculated
and updated. Is there a way to format the E column cells in
advance...without anything being in the D column right now?

"Bob I" wrote:


There must be something in the D column, so fix with
IF(D20,D2+E1,"")

Jennifer wrote:


I copied this formula into the spreadsheet; however, it shows "FALSE" in the
cells below the running total. Basically, I am trying to create a
spreadsheet that I can continually log into and add additional information,
and have the running total continue to update. In order to do that, I have
to format cells that do not have any information in them yet. However, once
I format them w/ the formula, then the data from the previous cells copies
down. Any suggestions on how to get rid of "FALSE"? Thanks,

"Bob I" wrote:



Put this in e2 and copy down.
IF(D2,d2+e1,"")

Jennifer wrote:



Hello. I have created a spreadsheet with very basic formulas. Basically, the
formulas are adding down columns to create running totals. For example,
column D is amount paid, and column E is amount paid to date. I have figured
out how to hide "zero" values, but in my running total column (E) the current
total appears all the way down thousands of sheets. Is there a way to have
the running total only appear on the lines that I have filled in information
for, and not repeat the same number for thousands of rows down? Hopefully
someone can help! Thanks so much,

Jennifer in Miami

Help with formatting
 

Can you post the formula you are using now


--


Regards,


Peo Sjoblom



"Jennifer" wrote in message
...
Bob I,

I understand now what you're telling me to do...and the formula works fine
for the data that I already have inputted. I want to format the specific
column for FUTURE data entry, which it won't let me do. Like you said,
there
has to be something in the D column in order for the formula to work. I'm
trying to format ahead of anticipated future entries, so that when the
user
logs in to input another set of data, that data is automatically
calculated
and updated. Is there a way to format the E column cells in
advance...without anything being in the D column right now?

"Bob I" wrote:

There must be something in the D column, so fix with
IF(D20,D2+E1,"")

Jennifer wrote:

I copied this formula into the spreadsheet; however, it shows "FALSE"
in the
cells below the running total. Basically, I am trying to create a
spreadsheet that I can continually log into and add additional
information,
and have the running total continue to update. In order to do that, I
have
to format cells that do not have any information in them yet. However,
once
I format them w/ the formula, then the data from the previous cells
copies
down. Any suggestions on how to get rid of "FALSE"? Thanks,

"Bob I" wrote:


Put this in e2 and copy down.
IF(D2,d2+e1,"")

Jennifer wrote:


Hello. I have created a spreadsheet with very basic formulas.
Basically, the
formulas are adding down columns to create running totals. For
example,
column D is amount paid, and column E is amount paid to date. I have
figured
out how to hide "zero" values, but in my running total column (E) the
current
total appears all the way down thousands of sheets. Is there a way to
have
the running total only appear on the lines that I have filled in
information
for, and not repeat the same number for thousands of rows down?
Hopefully
someone can help! Thanks so much,

Jennifer in Miami