Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula
In C2
=IF(B2="", "", B2-B1) copy down as needed. Column C will show blank until you type in a number in column B of that row. -- Hope that helps. Vergel Adriano "Dee" wrote: What do I need to do to correct this. I have a column that will be filled in with numbers each week. Column B. In column B I want a running total, subtracting one cell in B from the previous cell. I also want a grand total at the bottom to add up all the cells in column C. EX. B C 3 157 4 155 2 5 152 3 and so on. If I put the formula =B3-B4 and so on down the column I get the correct answer in C4 but in column C5,C6 etc it shows 155 until I put something in the B5. Column then shows the higher number which is the 155. Is there a way to enter the formula OR the correct formula to do what I want or is this unrealistic? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|