need to make cell blank if no data in that row
 

I have a data in columns, I want data to be shown only if there is
data in that row if no data then leave it blank (here is what I am
asking for)

Stock trade Gain/Loss Gain/Loss all trades
abc 4.18% 4.18%
def 3.77% 7.95%
[no trade] N/A 7.95%
[no trade] N/A 7.95%

i want trade column to appear blank in cell of gain/loss for all
trade instead of showing 7.95%. if no trade made


If there is no data but the formula is in column, third line shows
7.95%, 4th line shows 7.95%, 5th line 7.95% and this is keep going as
there is formula there. I want to to make if there is no data in
GAIN/
LOSS column then GAIN/LOSS FOR ALL TRADES to appear blank

need to make cell blank if no data in that row
 

=IF(ISNUMBER(B2),yourformula,"")


Gord Dibben MS Excel MVP

On Thu, 04 Oct 2007 14:24:46 -0700, chusu wrote:

I have a data in columns, I want data to be shown only if there is
data in that row if no data then leave it blank (here is what I am
asking for)

Stock trade Gain/Loss Gain/Loss all trades
abc 4.18% 4.18%
def 3.77% 7.95%
[no trade] N/A 7.95%
[no trade] N/A 7.95%

i want trade column to appear blank in cell of gain/loss for all
trade instead of showing 7.95%. if no trade made


If there is no data but the formula is in column, third line shows
7.95%, 4th line shows 7.95%, 5th line 7.95% and this is keep going as
there is formula there. I want to to make if there is no data in
GAIN/
LOSS column then GAIN/LOSS FOR ALL TRADES to appear blank

need to make cell blank if no data in that row
 

thanyou for such a great help







On Oct 4, 8:19 pm, Gord Dibben <gorddibbATshawDOTca wrote:
=IF(ISNUMBER(B2),yourformula,"")

Gord Dibben MS Excel MVP



On Thu, 04 Oct 2007 14:24:46 -0700, chusu wrote:
I have a data in columns, I want data to be shown only if there is
data in that row if no data then leave it blank (here is what I am
asking for)

Stock trade Gain/Loss Gain/Loss all trades
abc 4.18% 4.18%
def 3.77% 7.95%
[no trade] N/A 7.95%
[no trade] N/A 7.95%

i want trade column to appear blank in cell of gain/loss for all
trade instead of showing 7.95%. if no trade made

If there is no data but the formula is in column, third line shows
7.95%, 4th line shows 7.95%, 5th line 7.95% and this is keep going as
there is formula there. I want to to make if there is no data in
GAIN/
LOSS column then GAIN/LOSS FOR ALL TRADES to appear blank- Hide quoted text -

- Show quoted text -

need to make cell blank if no data in that row
 

On Oct 4, 9:46 pm, Jontie wrote:
thanyou for such a great help

On Oct 4, 8:19 pm, Gord Dibben <gorddibbATshawDOTca wrote:



=IF(ISNUMBER(B2),yourformula,"")

Gord Dibben MS Excel MVP

On Thu, 04 Oct 2007 14:24:46 -0700, chusu wrote:
I have a data in columns, I want data to be shown only if there is
data in that row if no data then leave it blank (here is what I am
asking for)

Stock trade Gain/Loss Gain/Loss all trades
abc 4.18% 4.18%
def 3.77% 7.95%
[no trade] N/A 7.95%
[no trade] N/A 7.95%

i want trade column to appear blank in cell of gain/loss for all
trade instead of showing 7.95%. if no trade made

If there is no data but the formula is in column, third line shows
7.95%, 4th line shows 7.95%, 5th line 7.95% and this is keep going as
there is formula there. I want to to make if there is no data in
GAIN/
LOSS column then GAIN/LOSS FOR ALL TRADES to appear blank- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -




thank you all for you answers my template is up on "Microsoft Online"
webpagenow here is the handy link in case you guys want to see your
contribution to it under search term of "Swing Trading Calculator"
and
link is [http://office.microsoft.com/en-us/templates/
TC300009021033.aspx?pid=CT101444811033]