Return result only if....

[Pat]

Before the formula =Sheet1!A1 in Sheet2! returns a result I want it to first
check Sheet2!D3 first and then and only then return the result if D3
contains a value.

Pat

 

[RagDyeR]

One way:

Entered in Sheet2:

=(D3<>"")*Sheet1!A1

If Sheet1 contains numbers

For text and numbers on Sheet1:

=IF(D3<>"",Sheet1!A1,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Before the formula =Sheet1!A1 in Sheet2! returns a result I want it to first
check Sheet2!D3 first and then and only then return the result if D3
contains a value.

Pat

 

[Guest]

Pat,

Try

=IF(ISBLANK(D3)=FALSE,Sheet1!A1," ")

The formula checks to see if cell D3 is blank. If it is it returns no
value. If it is not it returns the value in Sheet1!A1.

 

[JulieD]

or if you want to ensure that D3 contains a number rather than text
(depending on what is meant by "value")

=IF(ISNUMBER(D3),Sheet1!A1,"")

Cheers
JulieD

 

[Pat]

Thank you everyone for your help.
Something I failed to mention is D3 contains a formula.
Except for =(D3<>"")*Sheet1!A1 almost all the formulas suggested work if I
delete the formula in D3.
What would be the solution now be, if any?

Pat


"John Mansfield"

 

[Pat]

Since my last post I have worked out what is needed, and here it is:

=IF(ISNUMBER(D3)*(D3<>1),"",Sheet1!A1)

Cheers