Thread: Formula IF OR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CaroleO CaroleO is offline
external usenet poster
 
Posts: 20
Default 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