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