need to make cell blank if no data in that row

  • Thread starter Thread starter chusu
  • Start date Start date
C

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
 
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)
Click to expand...
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%
Click to expand...
i want trade column to appear blank in cell of gain/loss for all
trade instead of showing 7.95%. if no trade made
Click to expand...
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 -
Click to expand...

- Show quoted text -
Click to expand...
 
thanyou for such a great help

=IF(ISNUMBER(B2),yourformula,"")
Click to expand...
Gord Dibben MS Excel MVP
Click to expand...
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 -
Click to expand...
Click to expand...
- Show quoted text -- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...




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]
 
Back
Top