![]() Question:I have a nesting OR function problem: I have tried many formulas but just can't get it right, can you help please?Īnswer: You can write an IF statement that uses the AND function and the OR function as follows: =IF(AND(C2>=1,C2<=9, F2="F",OR(F3="D",F3="F",F3="B",F3="L",F3="R",F3="C")),1,0) Question: I have been looking at your Excel IF, AND and OR sections and found this very helpful, however I cannot find the right way to write a formula to express if C2 is either 1,2,3,4,5,6,7,8,9 and F2 is F and F3 is either D,F,B,L,R,C then give a value of 1 if not then 0. ![]() Otherwise, it will return the value in cell A1. In this example, the formula will return 0 if cell A1 was either less than 150,000 or greater than 250,000. Otherwise, it should return A1.Īnswer: You can use the OR function to perform an OR condition in the If function as follows: =IF(OR(A1250000),0,A1) Question: In Microsoft Excel, I'm trying to use the If function to return 0 if cell A1 is either 250,000.
0 Comments
Leave a Reply. |