ExamVeda
Login
Home
This question belongs to Computer Fundamentals MS Excel
MS Excel
?

Multiple calculations can be made in a single formula using

Answer & Solution
Correct Answer: Option B
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
Suneil Kumar
Suneil Kumar 5 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)