Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) |