Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > excel question

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

excel question

Reply to Message Icon

Name: fight
Date: September 17, 2008 at 19:58:50 Pacific
OS: xp
CPU/Ram: 2g
Product: hp
Comment:

I have set a cell equal to another cell.
Eg. If i set the cell B2 with the Formula "=A1" , so any value i type in in cell A1 would automatically update the cell in B2. The problem is that if i dont type in anything in A1, it will show "0" in B2. Is there a way to hide the "0" if no value is inputted in A1. Many thanks



Sponsored Link
Ads by Google

Response Number 1
Name: jon_k
Date: September 18, 2008 at 04:04:41 Pacific
Reply:

there are two ways:

1) on excel 2003, got to Tools/Options... and on the View pane take the tick out the box where it says "zero values". On Excel 07 this is located in Office Button/Excel Options/Advanced/Display Options for this Worksheet (nice and easy to find, eh?)

2) Change your formula to be a bit more complex:

=IF(LEN(A1)=0,"",B1)


0

Response Number 2
Name: DerbyDad03
Date: September 18, 2008 at 06:09:46 Pacific
Reply:

Jon, I assume you meant:

=IF(LEN(A1)=0,"",A1)

Other options include:

=IF(A1<>"",A1,"")
=IF(A1="","",A1)

I'm sure there are many others.


0

Response Number 3
Name: fight
Date: September 18, 2008 at 18:46:48 Pacific
Reply:

thanks so much for both your help


0

Response Number 4
Name: jon_k
Date: September 19, 2008 at 02:14:22 Pacific
Reply:

oops yeah DD I'm sure I meant that...just testing :)


0

Response Number 5
Name: DerbyDad03
Date: September 19, 2008 at 05:57:29 Pacific
Reply:

We could play all day...

=IF(NOT(A1=(LEN(A1)-LEN(A1))),VLOOKUP(A1,A1:A1,1,0),"")

=IF(NOT(NOT(ISERROR(VLOOKUP(A1,A1:A1,1,0)))),"",LOOKUP(A1,A1:A1,A1:A1))


0

Related Posts

See More



Sponsored Link
Ads by Google
Reply to Message Icon



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: excel question
excel question www.computing.net/answers/office/excel-question/7647.html

Microsoft Excel question www.computing.net/answers/office/microsoft-excel-question/2320.html

Excel Questions (Office XP) www.computing.net/answers/office/excel-questions-office-xp/1117.html