| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create If statement that returns a tick when true | Excel Discussion (Misc queries) | |||
| sum of blank cells returns zeros | Excel Worksheet Functions | |||
| If Statement returns true when false? | Excel Discussion (Misc queries) | |||
| nested if statement returns #value error | Excel Discussion (Misc queries) | |||
| Lookup returns #NA when search value (text) has leading zeros. | Excel Worksheet Functions | |||
Linear Mode
