Formula IF OR
 

I can get =IF(AND(H3H2,H3<H4),"No","") and =IF(T3<.49,"No","") to work
individually, but am encountering problems putting the two in the same
formula. H is in date format, and T is the result of a formula.

=IF((OR(AND(H108H107,H108<H109))*T108<0.49),"No", "") results in #VALUE.

What I need is IF H... OR T...,"No",""

TIA,
CaroleO

Formula IF OR
 

=IF(OR(AND(H108?h107,h108<h109),T108<.49),"No","")

I don't know why you would be trying to multiply T108<.49 in your original
formula.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CaroleO" wrote:

I can get =IF(AND(H3H2,H3<H4),"No","") and =IF(T3<.49,"No","") to work
individually, but am encountering problems putting the two in the same
formula. H is in date format, and T is the result of a formula.

=IF((OR(AND(H108H107,H108<H109))*T108<0.49),"No", "") results in #VALUE.

What I need is IF H... OR T...,"No",""

TIA,
CaroleO

Formula IF OR
 

Thanks, Dave. I don't know why either!

CaroleO

"Dave F" wrote:

=IF(OR(AND(H108?h107,h108<h109),T108<.49),"No","")

I don't know why you would be trying to multiply T108<.49 in your original
formula.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CaroleO" wrote:

I can get =IF(AND(H3H2,H3<H4),"No","") and =IF(T3<.49,"No","") to work
individually, but am encountering problems putting the two in the same
formula. H is in date format, and T is the result of a formula.

=IF((OR(AND(H108H107,H108<H109))*T108<0.49),"No", "") results in #VALUE.

What I need is IF H... OR T...,"No",""

TIA,
CaroleO

Formula IF OR
 

Note I have a typo in my formula. Should be:
=IF(OR(AND(H108h107,h108<h109),T108<.49),"No","")

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CaroleO" wrote:

Thanks, Dave. I don't know why either!

CaroleO

"Dave F" wrote:

=IF(OR(AND(H108?h107,h108<h109),T108<.49),"No","")

I don't know why you would be trying to multiply T108<.49 in your original
formula.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"CaroleO" wrote:

I can get =IF(AND(H3H2,H3<H4),"No","") and =IF(T3<.49,"No","") to work
individually, but am encountering problems putting the two in the same
formula. H is in date format, and T is the result of a formula.

=IF((OR(AND(H108H107,H108<H109))*T108<0.49),"No", "") results in #VALUE.

What I need is IF H... OR T...,"No",""

TIA,
CaroleO