Multiple calculations can be made in a single formula using

A. Standard formulas

B. Array formula

C. Complex formulas

D. Smart formula

Answer: Option B

Solution(By Examveda Team)

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.

Join The Discussion

Comments ( 1 )

  1. Suneil Kumar
    Suneil Kumar :
    2 years ago

    I want to put formula with multiple choice in one column as follow: Sale is D1 & Purchase is B1&C1. Please help.
    If A1=Visa then put D1-C1-B1 / 1.05 (Tax on Service charges only)
    If A1=Insurance the D1-C1-B1 / 1.05
    If A1=Tickets then put 0 (No Taxable Amt)
    If A1=Hotels the put D1 (Full Taxable)

Related Questions on MS Excel