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