| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
