software

Hi,

I have formulas in A1,B1,C1 etc in worksheet2 to populate the data from
worksheet1. In one of the columns in worksheet2, lets say F1, i have a
condition in such a way that if the corresponding value in WS1 is 0 then the
whole row should be empty. In other words, even tho A4, B4, C4, have formulas
and some value populated in it, if F4 has 0 the whole 4th row should be
blank...is there any way i do this? Any help wld be appreciated. Thanks

Yes, you can add an IF statement to each of your formulas (A1, B1, C1...)

So, in A1 you could enter:

=IF(F1=0,quot;quot;,your formula)

This first checks F1 to see if it equals 0. If TRUE, then it returns a
blank quot;quot;. If FALSE, then it performs your formula.

Repeat for B1, C1 and any others.

HTH,
Elkar

quot;nickquot; wrote:

gt; Hi,
gt;
gt; I have formulas in A1,B1,C1 etc in worksheet2 to populate the data from
gt; worksheet1. In one of the columns in worksheet2, lets say F1, i have a
gt; condition in such a way that if the corresponding value in WS1 is 0 then the
gt; whole row should be empty. In other words, even tho A4, B4, C4, have formulas
gt; and some value populated in it, if F4 has 0 the whole 4th row should be
gt; blank...is there any way i do this? Any help wld be appreciated. Thanks

You could use this formula:

=IF(ISERROR(MATCH(0,Sheet1!$A$1:$F$1,0)),Sheet1!A1 ,quot;quot;)

where Sheet1!$A$1:$F$1 are the boundries in worksheet one of the row you are
checking (Note, if you want to fill-down this formula, you should probably
write it: Sheet1!$A1:$F1)

and Sheet1!A1 is the corresponding cell in Sheet1 to the cell where you are
entering this formula in Sheet2 (which will have data if there is not a zero
in this row)

--
Anne Murrayquot;nickquot; wrote:

gt; Hi,
gt;
gt; I have formulas in A1,B1,C1 etc in worksheet2 to populate the data from
gt; worksheet1. In one of the columns in worksheet2, lets say F1, i have a
gt; condition in such a way that if the corresponding value in WS1 is 0 then the
gt; whole row should be empty. In other words, even tho A4, B4, C4, have formulas
gt; and some value populated in it, if F4 has 0 the whole 4th row should be
gt; blank...is there any way i do this? Any help wld be appreciated. Thanks

Thanx

quot;Elkarquot; wrote:

gt; Yes, you can add an IF statement to each of your formulas (A1, B1, C1...)
gt;
gt; So, in A1 you could enter:
gt;
gt; =IF(F1=0,quot;quot;,your formula)
gt;
gt; This first checks F1 to see if it equals 0. If TRUE, then it returns a
gt; blank quot;quot;. If FALSE, then it performs your formula.
gt;
gt; Repeat for B1, C1 and any others.
gt;
gt; HTH,
gt; Elkar
gt;
gt; quot;nickquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I have formulas in A1,B1,C1 etc in worksheet2 to populate the data from
gt; gt; worksheet1. In one of the columns in worksheet2, lets say F1, i have a
gt; gt; condition in such a way that if the corresponding value in WS1 is 0 then the
gt; gt; whole row should be empty. In other words, even tho A4, B4, C4, have formulas
gt; gt; and some value populated in it, if F4 has 0 the whole 4th row should be
gt; gt; blank...is there any way i do this? Any help wld be appreciated. Thanks

Thank you

quot;FinRazelquot; wrote:

gt; You could use this formula:
gt;
gt; =IF(ISERROR(MATCH(0,Sheet1!$A$1:$F$1,0)),Sheet1!A1 ,quot;quot;)
gt;
gt; where Sheet1!$A$1:$F$1 are the boundries in worksheet one of the row you are
gt; checking (Note, if you want to fill-down this formula, you should probably
gt; write it: Sheet1!$A1:$F1)
gt;
gt; and Sheet1!A1 is the corresponding cell in Sheet1 to the cell where you are
gt; entering this formula in Sheet2 (which will have data if there is not a zero
gt; in this row)
gt;
gt; --
gt; Anne Murray
gt;
gt;
gt; quot;nickquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I have formulas in A1,B1,C1 etc in worksheet2 to populate the data from
gt; gt; worksheet1. In one of the columns in worksheet2, lets say F1, i have a
gt; gt; condition in such a way that if the corresponding value in WS1 is 0 then the
gt; gt; whole row should be empty. In other words, even tho A4, B4, C4, have formulas
gt; gt; and some value populated in it, if F4 has 0 the whole 4th row should be
gt; gt; blank...is there any way i do this? Any help wld be appreciated. Thanks