need cell appeat 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 cell appeat blank if no data in that row
 

Two of you with exactly the same problem withing two minutes of each other?

What are the formulas for Gain/Loss & Gain/Loss all trades?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jontie" wrote in message
ups.com...
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 cell appeat blank if no data in that row
 

that one is also mine but I deleted that to put in a correct place i
have deleted first one

here is the formula


for gain/loss

=IF(ISERR(M6/H6),"N/A",(M6/H6))
=IF(ISERR(M7/H7),"N/A",(M7/H7))
=IF(ISERR(M8/H8),"N/A",(M8/H8)) and so on......


gain loss for all trades

=SUM($K$6:K6)
=SUM($K$6:K7)
=SUM($K$6:K8) and so on......

http://spreadsheets.google.com/pub?k...tBoeBJUpVfwaZA
here is the file if you want to take a look

thank you very much for helping me (you have previously answered my
question)

need cell appeat blank if no data in that row
 

Try:

=IF(A6="","",IF(ISERR(M6/H6),"N/A",(M6/H6)))

and

=IF(A6="","",SUM($K$6:K6))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jontie" wrote in message
ups.com...
that one is also mine but I deleted that to put in a correct place i
have deleted first one

here is the formula


for gain/loss

=IF(ISERR(M6/H6),"N/A",(M6/H6))
=IF(ISERR(M7/H7),"N/A",(M7/H7))
=IF(ISERR(M8/H8),"N/A",(M8/H8)) and so on......


gain loss for all trades

=SUM($K$6:K6)
=SUM($K$6:K7)
=SUM($K$6:K8) and so on......

http://spreadsheets.google.com/pub?k...tBoeBJUpVfwaZA
here is the file if you want to take a look

thank you very much for helping me (you have previously answered my
question)