Turn off chart

[Mickey Mouse]

I created a worksheet for a friend to record receipts.
He hit the F11 key by mistake and was presented with a chart.
Well, try as we may we couldn't get back to the sheet I created.
In the end I had to delete the xl file and reload a new copy and re enter
data.
Can someone tell me what I should have done to get back from the chart to my
sheet?
XL2002 SP3

Mickey

 

[Nick Hodge]

Mickey

All that will have done is set up a new sheet tab at the bottom with a chart
on it...just right-click the 'Chart1' sheet tab and select delete and then
OK. If you still don't end up on the original sheet, just select it on the
sheet tabs at the bottom of the window

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Mickey Mouse]

Thankyou Nick, problem solved.

Mickey

I'm now posting another problem.
example:
Value in cell B1 is $10.00
Value in cell C1 is $5.00
Formula in D1 is =sum(b1-c1) which displays a balance of $5.00.
If the Value in C1 is $10.00 then D1 displays $0.00
I would like D1 to display a blank cell instead of $0.00

Mickey

 

[Brian]

Formula in D1:
=if(sum(b1-c1)>0,sum(b1-c1),"")

Thankyou Nick, problem solved.

Mickey

I'm now posting another problem.
example:
Value in cell B1 is $10.00
Value in cell C1 is $5.00
Formula in D1 is =sum(b1-c1) which displays a balance of $5.00.
If the Value in C1 is $10.00 then D1 displays $0.00
I would like D1 to display a blank cell instead of $0.00

Mickey

 

[Mickey Mouse]

Formula in D1:
=if(sum(b1-c1)>0,sum(b1-c1),"")

Thanks Brian, how do I add this formula to the formula already in D1?

Formula in D1 is currently =sum(b1-c1)

I tried this but got an error
=sum(b1-c1),if(sum(b1-c1)>0,sum(b1-c1),"")
How do you combine the two formula, with a comma?

Mickey

 

[Beege]

Mickey,

In D1
Try =IF(B1-C1>0,B1-C1,"")

Don't need to use =SUM here.

Beege

 

[Beege]

Mickey,

Don't try to "add to the formula", just replace your formula with the
suggested formula. It'll work fine!

Beege

 

[OM]

Go to Tools, Options, View, and in thwe Window Options pane (at the bottom)
UNCHECK "Zero Values". This gives you a blank cell for a zero (the zero is
actually there, but not displayed) which means that cells that rely on a
numerical value there aren't stuffed up.

Rob

 

[Mickey Mouse]

Thanks Rob, this is much simpler than the formula I use to achieve the same
result.
Your answer is so simple in fact that I must ask, is there an up or down
side to unchecking "zero values"?
Once again, thanks.

Mickey