If problem
 

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

If problem
 

Looks fine, what problem are you experiencing?

--
HTH

Bob Phillips

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

"sedonovan" wrote in message
...
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

If problem
 

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


Hi Suzanne,

the formula seems to work fine...

What is the results you have?


--
Ciao

Franz Verga from Italy

If problem
 

"sedonovan" wrote in message
...
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.

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.
--
David Biddulph

If problem
 

Not he won't, it shows as zero

--
HTH

Bob Phillips

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

"David Biddulph" wrote in message
...
"sedonovan" wrote in message
...
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.

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.
--
David Biddulph