If problem

S

sedonovan

Can you tell me what's wrong with this formula please

=if(sheet1!A2<>"",sheet1!a2,"")

that is (being in sheet2)
if there's a value in A2 on sheet1
copy it/reference it on sheet2
if not, leave blank.

Many thanks,
Suzanne
 
B

Bob Phillips

Looks fine, what problem are you experiencing?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
F

Franz Verga

Nel post *sedonovan* ha scritto:
Can you tell me what's wrong with this formula please

=if(sheet1!A2<>"",sheet1!a2,"")

that is (being in sheet2)
if there's a value in A2 on sheet1
copy it/reference it on sheet2
if not, leave blank.

Many thanks,
Suzanne
Click to expand...


Hi Suzanne,

the formula seems to work fine...

What is the results you have?
 
D

David Biddulph

sedonovan said:
Can you tell me what's wrong with this formula please

=if(sheet1!A2<>"",sheet1!a2,"")

that is (being in sheet2)
if there's a value in A2 on sheet1
copy it/reference it on sheet2
if not, leave blank.
Click to expand...

Nothing wrong with the formula, but of course you'd get a very similar
result with the simpler formula =sheet1!A2, as you're putting a blank where
you're finding a blank.
 
B

Bob Phillips

Not he won't, it shows as zero

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top