Return result only if....
 

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

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!
==============================================


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

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.

----
Regards,
John Mansfield
http://www.pdbook.com

"Pat" wrote:

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

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


"RagDyeR" wrote in message
.. .
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!
==============================================


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

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

----
Regards,
John Mansfield
http://www.pdbook.com

"Pat" wrote:

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

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

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

Cheers

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

----
Regards,
John Mansfield
http://www.pdbook.com

"Pat" wrote:

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