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

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

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

"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

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