Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell as zero
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell as zero
Something of this form:
=IF(A1=0,Action1,Action2) Action1 is "last cumulative value" (?) Action2 is "last cumulative value" - A1 Or if you want the cell to blank for future dates: =if(A1=0,"",B1-A1) HTH "patt" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell as zero
Would this work? Tools|Option|remove the check mark in the "zero values" box. -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=561157 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |