Need cells to show as zero or empty
 

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(C420000,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!

Need cells to show as zero or empty
 

Test for B4 is blank first

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

--
Ian
--
"BelkyBear" wrote in message
...
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(C420000,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!

Need cells to show as zero or empty
 

Thank you Ian.

"Ian" wrote:

Test for B4 is blank first

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

--
Ian
--
"BelkyBear" wrote in message
...
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(C420000,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!

Need cells to show as zero or empty
 

Glad to help. Thanks for the feedback.

--
Ian
--
"BelkyBear" wrote in message
...
Thank you Ian.

"Ian" wrote:

Test for B4 is blank first

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

--
Ian
--
"BelkyBear" wrote in message
...
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(C420000,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!