blank cell turns to 0

[LMB]

Hi Guys,

Using Excel 2000. I am trying to work on a sheet someone else started but
can't finish. In a cell on the sheet that the formula below is pulling the
data from there is a blank field but there is a 0 in the cell that has this
formula in it on my new sheet. If the cell on the first sheet is blank, I
want the cell that equals that cell on my second sheet to be blank too.

='SVMMC-admin, tx, blue cards'!$B$3

The sheet is a yes/no sheet and when there is a 1 in the cell it means yes,
when there is a 0 in the cell it means no, when the cell is blank, it means
Not Applicable so when the blank cell converts to a 0 that changes the data.
Hope this makes sense.

Thanks,
Linda

[MartinShort]

Hi Linda

The easiest way round this is to use an IF statement. eg.

Please Login or Register  to view this content.

will put the contents of A1 into your new cell or a blank if there's nothing to put in ie it will weed out all of those annoying zeros. You can also nest the original formula into your IF statement. It makes it harder to read, but saves space.

MS

[JE McGimpsey]

Try:

=IF('SVMMC-admin, tx, blue cards'!$B$3="","",'SVMMC-admin, tx, blue
cards'!$B$3)



In article <#[email protected]>,
"LMB" <[email protected]> wrote:

> Using Excel 2000. I am trying to work on a sheet someone else started but
> can't finish. In a cell on the sheet that the formula below is pulling the
> data from there is a blank field but there is a 0 in the cell that has this
> formula in it on my new sheet. If the cell on the first sheet is blank, I
> want the cell that equals that cell on my second sheet to be blank too.
>
> ='SVMMC-admin, tx, blue cards'!$B$3
>
> The sheet is a yes/no sheet and when there is a 1 in the cell it means yes,
> when there is a 0 in the cell it means no, when the cell is blank, it means
> Not Applicable so when the blank cell converts to a 0 that changes the data.
> Hope this makes sense.

[LMB]

That worked! Thank-you.


"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> Try:
>
> =IF('SVMMC-admin, tx, blue cards'!$B$3="","",'SVMMC-admin, tx, blue
> cards'!$B$3)
>
>
>
> In article <#[email protected]>,
> "LMB" <[email protected]> wrote:
>
>> Using Excel 2000. I am trying to work on a sheet someone else started
>> but
>> can't finish. In a cell on the sheet that the formula below is pulling
>> the
>> data from there is a blank field but there is a 0 in the cell that has
>> this
>> formula in it on my new sheet. If the cell on the first sheet is blank,
>> I
>> want the cell that equals that cell on my second sheet to be blank too.
>>
>> ='SVMMC-admin, tx, blue cards'!$B$3
>>
>> The sheet is a yes/no sheet and when there is a 1 in the cell it means
>> yes,
>> when there is a 0 in the cell it means no, when the cell is blank, it
>> means
>> Not Applicable so when the blank cell converts to a 0 that changes the
>> data.
>> Hope this makes sense.