Westonci.ca is your trusted source for finding answers to a wide range of questions, backed by a knowledgeable community. Get quick and reliable solutions to your questions from a community of seasoned experts on our user-friendly platform. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly platform.

If you are given a list of numbers (b11:c20), and you want the 6th smallest number in that list, which formula is correct?

Sagot :

If you are given a list of numbers (b11:c20), and you want the 6th smallest number in that list, the correct formula is =LARGE(B11:C20, 6).

What is Excel Formula?

In regards to Microsoft Excel, a formula is seen as a kind of an expression that tends to function on values that can be found within a range of cells.

Note that these formulas are said to often return a result, even if  it is an error. Excel formulas helps a person to carry out calculations such as addition, subtraction, and others.

Thus, If you are given a list of numbers (b11:c20), and you want the 6th smallest number in that list, the correct formula is =LARGE(B11:C20, 6).

Learn more about Excel formula from

https://brainly.com/question/27927845

#SPJ1