=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