If statement returns zeros

R

Rich D

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?
 
T

T. Valko

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

As a general template:

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

Rich D

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 said:
You should have posted the formula you're using...

As a general template:

=IF(your_formula="","",your_formula)
Click to expand...
 
T

T. Valko

Try this:

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

--
Biff
Microsoft Excel MVP


Rich D said:
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
______________.
Click to expand...
 
D

David Biddulph

=IF($I$2="NO",IF(Clauses!$B5="","",Clauses!$B5),IF(Clauses!B17="","",Clauses!B17))--David Biddulph"Rich D" <[email protected]> wrote in messageHere 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" <[email protected]> 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>>>>>>
 
Top