need to make cell blank if no data in that row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chusu - 04 Oct 2007 22:24 GMT

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

Reply to this Message

Gord Dibben - 05 Oct 2007 01:19 GMT

=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
[quoted text clipped - 14 lines]
>GAIN/
>LOSS column then GAIN/LOSS FOR ALL TRADES to appear blank

Reply to this Message

Jontie - 05 Oct 2007 02:46 GMT

thanyou for such a great help

> =IF(ISNUMBER(B2),yourformula,"")
>
[quoted text clipped - 20 lines]
>
> - Show quoted text -

Reply to this Message

Jontie - 24 Oct 2007 20:10 GMT

> thanyou for such a great help
>
[quoted text clipped - 24 lines]
>
> - 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]

Reply to this Message