Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi. I have a cumulative budget worksheet where I add weekly numbers and will
show a profit/loss for each week as I go. It worked fine last year! but whatever I did now, it picks up the blank cell (weeks I haven't come to yet) as zero and so automatically shows all those weeks as losses all the way down the page. How can I get it to not pick up a cell as zero? To not subtract that cell unless there is a number in it? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions |