how to use microsoft excel 2010 formulas

This formula will return K9/N7 if cell C9 is either 4 or 0. If the '4 or 0' conditions exists in Column C I want Column K divided by Column N and the answer to be placed in Column M and associated rowĪnswer:You should be able to use the OR function within your IF function to test for C9=4 OR C9=0 as follows: =IF(C9=1,K9/J7,IF(C9=2,K9/J7,IF(C9=3,K9/L7,IF(OR(C9=4,C9=0),K9/N7)))) The problem is on how to write the 'or' condition when a '4 or 0' exists in Column C.

In Cell C9, I can have an input of 1, 2, 3, 4 or 0.

Question:I have a nesting OR function problem: The advantage of using the new IFS functions is that you can specify a series of conditions in a single function. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. 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) The IF function is one of the most commonly used functions in Excel, and using IF inside IF (nested IF functions) has been a common practice in Excel, but it can be challenging or confusing at times. There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. 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.

How to use microsoft excel 2010 formulas