need to make cell blank if no data in that row

[chusu]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Jontie]

thanyou for such a great help

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

Gord Dibben MS Excel MVP

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 -

 

[Jontie]

thanyou for such a great help

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

Gord Dibben MS Excel MVP

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]