Returning a value rather than TRUE or FALSE.
 

I have a formula that seems to be working OK. It is If H14 ="",and Cond 1 OR
condit 2 Or Cond 3 are met, then return the actual value from G14, otherwise
return the value from H14. When H14 is blank, and any of the OR conditions
are met, it returns "TRUE"...How can I get it to return the actual value that
is in G14, rather than "TRUE"?

Thanks
--
Rich D
Armstrong Custom Homes
Redmond

Returning a value rather than TRUE or FALSE.
 

Post the formula so we can see what your OR conditions are.

Basically, it sounds like you need something like this:

=IF(AND(H14="",OR(Cond1,Cond2,Cond3)),G14,H14)

--
Biff
Microsoft Excel MVP


"Rich D" wrote in message
...
I have a formula that seems to be working OK. It is If H14 ="",and Cond 1
OR
condit 2 Or Cond 3 are met, then return the actual value from G14,
otherwise
return the value from H14. When H14 is blank, and any of the OR
conditions
are met, it returns "TRUE"...How can I get it to return the actual value
that
is in G14, rather than "TRUE"?

Thanks
--
Rich D
Armstrong Custom Homes
Redmond

Returning a value rather than TRUE or FALSE.
 

=IF(AND(H14 ="",OR(Cond1,Cond2,Cond3)),G14,H14)

--
__________________________________
HTH

Bob

"Rich D" wrote in message
...
I have a formula that seems to be working OK. It is If H14 ="",and Cond 1
OR
condit 2 Or Cond 3 are met, then return the actual value from G14,
otherwise
return the value from H14. When H14 is blank, and any of the OR
conditions
are met, it returns "TRUE"...How can I get it to return the actual value
that
is in G14, rather than "TRUE"?

Thanks
--
Rich D
Armstrong Custom Homes
Redmond

Returning a value rather than TRUE or FALSE.
 

Hi,

A bit difficult to unravel without your formula as an example but try this,

=IF(H14<"",IF(OR(H14=1,H14=2,H14=3),G14,""),"")

Mike

"Rich D" wrote:

I have a formula that seems to be working OK. It is If H14 ="",and Cond 1 OR
condit 2 Or Cond 3 are met, then return the actual value from G14, otherwise
return the value from H14. When H14 is blank, and any of the OR conditions
are met, it returns "TRUE"...How can I get it to return the actual value that
is in G14, rather than "TRUE"?

Thanks
--
Rich D
Armstrong Custom Homes
Redmond