Nested IF statement Help

K

kastnna

I have two sheets in a workbook (Sht1 & Sht2). I have a list of names
in column A of Sht1. I want Column A in Sht2 to mirror Column A in
Sht1. I entered "='Sht1'!A2" in Sht2 cell A2 and this works, but if the
cell in Sht1 is blank, then the cell in Sht2 displays 0.

I need help getting around this. I figured an IF statment could
probably do it, but need help with the formula.

Thanks
 
I

Ian

One option is to disable the display of zero values on Sht2, unless this
conflicts with something else in the workbook.

Select Sht2 then go to Tools>Options>View and deselect Zero values. The
disables the display of zero values just on the selected sheet (Excel 2002),
but may differ in other versions.
 
K

kastnna

Good idea, but the sheet will have numbers in it and cells that only
display zeros.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count to Table Format 0
worksheet function... 7
Macro in one workbook that names a range in a different workbook 2
help with syntax for copy and pasting rows across sheets 4
Compare two wk sheets with common data using copy paste macro 0
writing a macro for search-match-copy 3
how do i run a search between two spreadsheets 0
Copy Column D from all worksheets in WB1 and paste in sheet1 WB2 10

Top