Need cells to show as zero or empty

[BelkyBear]

Hello,

A couple of people helped with this spreadsheet, but I decided to add a
couple of more columns at the end (F & G):

A B C D E F G
1 161,700 180000 18300 0 0 -1700 (25.5)
2 180,000 200000 20000 0 0 0 0
3 200,000 221000 21000 1000 $15 0 0
4 221,000 0 0 0 -20000 (300)
5 -20000 (300)

A4: =IF(B3="","",SUM(B3))
B4: no formula
C4: =IF(B4="",0,SUM(B4-A4))
D4: =IF(C4>20000,C4-20000,0)
E4: =SUM(D4*0.015)
F4: =IF(C4<20000,C4-20000,0)
G4: =SUM(F4*0.015)

Column F: If column C is < 20,000, then subtract 20,000; if not, enter
zero. The formula I have in column F works only if there is a value in column
C. Since the month in row 4 (and 5) is in the future, there is no value
entered for column B; therefore column C is zero.

I need columns F & G to be zero (or empty) even when there is no value in
column B. Help anyone?

Thanks!

[Ian]

Test for B4 is blank first

=IF(B4="","",your original formula here)

--
Ian
--
"BelkyBear" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> A couple of people helped with this spreadsheet, but I decided to add a
> couple of more columns at the end (F & G):
>
> A B C D E F G
> 1 161,700 180000 18300 0 0 -1700 (25.5)
> 2 180,000 200000 20000 0 0 0 0
> 3 200,000 221000 21000 1000 $15 0 0
> 4 221,000 0 0 0 -20000 (300)
> 5 -20000 (300)
>
> A4: =IF(B3="","",SUM(B3))
> B4: no formula
> C4: =IF(B4="",0,SUM(B4-A4))
> D4: =IF(C4>20000,C4-20000,0)
> E4: =SUM(D4*0.015)
> F4: =IF(C4<20000,C4-20000,0)
> G4: =SUM(F4*0.015)
>
> Column F: If column C is < 20,000, then subtract 20,000; if not, enter
> zero. The formula I have in column F works only if there is a value in
> column
> C. Since the month in row 4 (and 5) is in the future, there is no value
> entered for column B; therefore column C is zero.
>
> I need columns F & G to be zero (or empty) even when there is no value in
> column B. Help anyone?
>
> Thanks!
>

[BelkyBear]

Thank you Ian.

"Ian" wrote:

> Test for B4 is blank first
>
> =IF(B4="","",your original formula here)
>
> --
> Ian
> --
> "BelkyBear" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> >
> > A couple of people helped with this spreadsheet, but I decided to add a
> > couple of more columns at the end (F & G):
> >
> > A B C D E F G
> > 1 161,700 180000 18300 0 0 -1700 (25.5)
> > 2 180,000 200000 20000 0 0 0 0
> > 3 200,000 221000 21000 1000 $15 0 0
> > 4 221,000 0 0 0 -20000 (300)
> > 5 -20000 (300)
> >
> > A4: =IF(B3="","",SUM(B3))
> > B4: no formula
> > C4: =IF(B4="",0,SUM(B4-A4))
> > D4: =IF(C4>20000,C4-20000,0)
> > E4: =SUM(D4*0.015)
> > F4: =IF(C4<20000,C4-20000,0)
> > G4: =SUM(F4*0.015)
> >
> > Column F: If column C is < 20,000, then subtract 20,000; if not, enter
> > zero. The formula I have in column F works only if there is a value in
> > column
> > C. Since the month in row 4 (and 5) is in the future, there is no value
> > entered for column B; therefore column C is zero.
> >
> > I need columns F & G to be zero (or empty) even when there is no value in
> > column B. Help anyone?
> >
> > Thanks!

[Ian]

Glad to help. Thanks for the feedback.

--
Ian
--
"BelkyBear" <[email protected]> wrote in message
news:[email protected]...
> Thank you Ian.
>
> "Ian" wrote:
>
>> Test for B4 is blank first
>>
>> =IF(B4="","",your original formula here)
>>
>> --
>> Ian
>> --
>> "BelkyBear" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hello,
>> >
>> > A couple of people helped with this spreadsheet, but I decided to add a
>> > couple of more columns at the end (F & G):
>> >
>> > A B C D E F G
>> > 1 161,700 180000 18300 0 0 -1700 (25.5)
>> > 2 180,000 200000 20000 0 0 0 0
>> > 3 200,000 221000 21000 1000 $15 0 0
>> > 4 221,000 0 0 0 -20000 (300)
>> > 5 -20000 (300)
>> >
>> > A4: =IF(B3="","",SUM(B3))
>> > B4: no formula
>> > C4: =IF(B4="",0,SUM(B4-A4))
>> > D4: =IF(C4>20000,C4-20000,0)
>> > E4: =SUM(D4*0.015)
>> > F4: =IF(C4<20000,C4-20000,0)
>> > G4: =SUM(F4*0.015)
>> >
>> > Column F: If column C is < 20,000, then subtract 20,000; if not, enter
>> > zero. The formula I have in column F works only if there is a value in
>> > column
>> > C. Since the month in row 4 (and 5) is in the future, there is no value
>> > entered for column B; therefore column C is zero.
>> >
>> > I need columns F & G to be zero (or empty) even when there is no value
>> > in
>> > column B. Help anyone?
>> >
>> > Thanks!