=IF(ISBLANK(Apple!A1), "", Apple!A1)

It'll return the value of Apple!A1 if a non-blank value exists, but return
blank is Apple!A1 is blank.

--
Location: Sydney
Occupation: Actuarial Consultant (Project Finance/Financial Modeling)


"seno" wrote:


Hi people of the superior power of excel,


I have 2 worksheets Apple and Orange.

Field A1 in Apple worksheet contains no information "blank" nothings
entered.

I want to copy the information in A1 Apple to A2 Orange.

I assumed Field A2 Orange = Apple!A1.
but the field shows the value 0. I changed the properties to text but
it still shows 0.

What is the correct formula to ensure field A2 Orange = "blank"?




--
seno