# How do you use two functions in Excel?

## How do you use two functions in Excel?

Use nested functions in a formula

1. Click the cell in which you want to enter the formula.
2. To start the formula with the function, click Insert Function on the formula bar .
3. In the Or select a category box, select All.
4. To enter another function as an argument, enter the function in the argument box that you want.

## How do you lookup two conditions in Excel?

Using two criteria to return a value from a table

1. =SUMPRODUCT((B3:B13=C16)*(C3:C13=C17)*(D3:D13))
2. =INDEX(C3:C13,SUMPRODUCT((B3:B13=C16)*(D3:D13=C18)*ROW(C3:C13)),0)
3. =LOOKUP(2,1/(B3:B13=C16)/(D3:D13=C18),(C3:C13))
4. {=INDEX(C3:C13,MATCH(1,(B3:B13=C16)*(D3:D13=C18),0))}

How do you use if and count function together in Excel?

Combining the IF and COUNTIF functions also let you have more than 254 logical expressions and the effort to type the formula is minimal.

1. Use IF + COUNTIF to evaluate multiple conditions. =IF(COUNTIF(\$B\$23:\$D\$25,B3),C3+100,””)
2. Use IF + COUNTIF to evaluate multiple conditions and calculate different outcomes.

For some, it’s about eating a balanced diet. For others, it’s about exercising and getting fit. You might be surprised, but Excel can help you plan, track, and organize your health and fitness goals with a robust offering of free and premium templates.