If statement returns zeros
 

I'm using the IF formula(?) to copy material from another sheet if a
condition is true. When the info I bring in has blank rows, it puts a 0 in
the row. How can I make it return blanks if the row is blank?
--
Rich D
Armstrong Custom Homes
Redmond

If statement returns zeros
 

You should have posted the formula you're using...

As a general template:

=IF(your_formula="","",your_formula)

--
Biff
Microsoft Excel MVP


"Rich D" wrote in message
...
I'm using the IF formula(?) to copy material from another sheet if a
condition is true. When the info I bring in has blank rows, it puts a 0
in
the row. How can I make it return blanks if the row is blank?
--
Rich D
Armstrong Custom Homes
Redmond

If statement returns zeros
 

IF(A1="","",your formula)


Gord Dibben MS Excel MVP

On Sat, 15 Dec 2007 10:16:00 -0800, Rich D
wrote:

I'm using the IF formula(?) to copy material from another sheet if a
condition is true. When the info I bring in has blank rows, it puts a 0 in
the row. How can I make it return blanks if the row is blank?

If statement returns zeros
 

Here is the formula I'm using: =IF($I$2="NO",Clauses!$B5,Clauses!B17)
I am then copying this down the rows where I want the info to go.

This is what it returns when it encounters a blank row: Note the zeros on
the left.

Thanks for your help.

1. $________________(20%) of contract price down
(including sales tax), prior to start of construction.
This amount will include deposits paid previously.
0
2. $________________ (20%) at completion of
______________.
0
3. $________________ (20%) at completion of
______________.
0
4. $________________ (20%) at completion of
______________.

--
Rich D
Armstrong Custom Homes
Redmond


"T. Valko" wrote:

You should have posted the formula you're using...

As a general template:

=IF(your_formula="","",your_formula)

--
Biff
Microsoft Excel MVP


"Rich D" wrote in message
...
I'm using the IF formula(?) to copy material from another sheet if a
condition is true. When the info I bring in has blank rows, it puts a 0
in
the row. How can I make it return blanks if the row is blank?
--
Rich D
Armstrong Custom Homes
Redmond

If statement returns zeros
 

Try this:

=IF($I$2="NO",IF(Clauses!$B5="","",Clauses!$B5),Cl auses!B17)

--
Biff
Microsoft Excel MVP


"Rich D" wrote in message
...
Here is the formula I'm using: =IF($I$2="NO",Clauses!$B5,Clauses!B17)
I am then copying this down the rows where I want the info to go.

This is what it returns when it encounters a blank row: Note the zeros on
the left.

Thanks for your help.

1. $________________(20%) of contract price down
(including sales tax), prior to start of construction.
This amount will include deposits paid previously.
0
2. $________________ (20%) at completion of
______________.
0
3. $________________ (20%) at completion of
______________.
0
4. $________________ (20%) at completion of
______________.

--
Rich D
Armstrong Custom Homes
Redmond


"T. Valko" wrote:

You should have posted the formula you're using...

As a general template:

=IF(your_formula="","",your_formula)

--
Biff
Microsoft Excel MVP


"Rich D" wrote in message
...
I'm using the IF formula(?) to copy material from another sheet if a
condition is true. When the info I bring in has blank rows, it puts a
0
in
the row. How can I make it return blanks if the row is blank?
--
Rich D
Armstrong Custom Homes
Redmond

If statement returns zeros
 

=IF($I$2="NO",IF(Clauses!$B5="","",Clauses!$B5),IF (Clauses!B17="","",Clauses!B17))--David Biddulph"Rich D" wrote in ... Here is the formula I'm using: =IF($I$2="NO",Clauses!$B5,Clauses!B17) I am then copying this down the rows where I want the info to go. This is what it returns when it encounters a blank row: Note the zeros on the left. Thanks for your help. 1. $________________(20%) of contract price down (including sales tax), prior to start of construction. This amount will include deposits paid previously. 0 2. $________________ (20%) at completion of ______________. 0 3. $________________ (20%) at completion of ______________. 0 4. $________________ (20%) at completion of ______________. -- Rich D Armstrong Custom Homes Redmond "T. Valko" wrote: You should have posted the formula you're using... As a general template: =IF(your_formula="","",your_formula) -- Biff Microsoft Excel MVP "Rich D" wrote in message ... I'm using the IF formula(?) to copy material from another sheet if a condition is true. When the info I bring in has blank rows, it puts a0 in the row. How can I make it return blanks if the row is blank? -- Rich D Armstrong Custom Homes Redmond