IF AND OR statement

[greendaffodil]

Hi everyone,

I've been trying to set up a formula in which IF, AND and OR should all be included. So far, my formula looks like this:

=IF(AND(C1079-C1078<-0,4; C1080-C1079<-0,4); "0"; "1")

Thus, if C1079-C1078<-0,4 and if C1080-C1079<-0,4 you'll get the condition 0.
Besides, I also want the condition to be zero if C1079-C1078<-0,9. However, I'm not sure how to add this in the formula.

Hopefully someone can help me.

-Daphne

[arthurbr]

Perhaps

Please Login or Register  to view this content.

[greendaffodil]

Thank you for your reply. In this formula condition zero will be achieved if C1079-C1078<-0,9 AND C1080-C1079<-0,4 right? But I want the condition to be zero if C1079-C1078<-0,9. Furthermore, if I add an AND expression to my already existing formula (=IF(AND(C1079-C1078<-0,4; C1080-C1079<-0,4); "0"; "1")), the conditions in which solely the conditions C1079-C1078<-0,4 in combination with C1080-C1079<-0,4, will no longer be seen as zero if C1079-C1078<-0,9 is not true. If that is what you mean, its not really what I'm looking for. Hopefully I've made myself more clear now?

Thus in short condition needs to be zero if:
condition 1: C1079-C1078<-0,4; C1080-C1079<-0,4
condition 2: C1079-C1078<-0,9

-Daphne

[SDCh]

may be like this:

Please Login or Register  to view this content.

[greendaffodil]

Thank you very much! That formula is correct.

[SDCh]

You are welcome.

If your problem is solved, please mark the thread as SOLVED >>Above your first post>>Thread Tools>> Mark your thread as Solved