Use of Excel curly braces {} data

Source: Internet
Author: User

First of all, the use of braces {} to include the data, which means that the data of the array of data, not equivalent to the general data, such as: {"A", "B", "C"} is the data of the array.

Let me introduce you to the use example of the braces {} data.

Look at the table first.

In the table, look at the product there, "37" This product, a total of three lines, then, how to find 37 of the total?

Look at the picture below and put 37 of the total in the B10.

Computer Tutorials

According to the conventional algorithm, 37 of the total amount should be equal to: =B2*C2+B5*C5+B7*C7, which is equivalent to 10*200+5*100+60*400, the total should be equal to 26500

Below, we use the curly braces {} data through the function to make a one-time result. Look at the table.

The formula we use in the table above is: {=sum (IF (a2:a7= "37", b2:b7*c2:c7,0)}, so you can calculate the result.

Notice Oh, you FX formula bar inside, we can only enter =sum (IF (a2:a7= "37", b2:b7*c2:c7,0) this formula, after entering the good, and pressed the ctrl+shift+enter of these three keys, will automatically add a pair of curly braces, This pair of curly braces is not entered, is pressed out, please note.

The meaning of this formula is: in A2:a7 this area, as long as there is a product name equal to "37", then the number of the row is multiplied by the unit price, and then the product of each row together to get the final result.

The computation process, satisfies the condition the first multiplication, then adds each product together, this is the result, as this example: B2*c2+b5*c5+b7*c7, multiplies and then adds first.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.