Things to know before admitting your kids to school

Here are few things that you must know or take care of before admitting your kids to school. If you are not taking care of these things, you might be putting you children to wrong school, risking life. Only irresponsible parents do this mistake who all do not love their children or one who are not serious about their children or one who are uneducated. So, let me guide you to few thins that you need to take care of before admitting your children to school. 1. See if school is registered to local registerer (respective government). 2. Check the classroom, bathroom, playground, kitchen, it needs to be clean. 3. Sit in the classroom for 5 to 10 min., see how they lecture children. 4. Check the school fee, other fee, transportation fee, see if you can afford. 5. Check the food they fed to children, how many times, they give food to children. 6. Check the school duration, start and end time, usually for children 4 to 8 hours, see for how long your student can sit in class. 7. Ask for holida...

How to do Custom Mathematical Operations in an Array in Excel

Using REDUCE function with LAMBDA, we can do the job. The REDUCE function in Excel 365 Dynamic Array is used to reduce a range or array of values to a single value using a specified operation. It is similar to the SUM function, but allows for more complex operations such as finding the maximum or minimum value.

Syntax: =REDUCE(array, operation)

Here, operation can be one of the following:

  • SUM: Returns the sum of the values in the array.
  • PRODUCT: Returns the product of the values in the array.
  • AVERAGE: Returns the average of the values in the array.
  • MAX: Returns the maximum value in the array.
  • MIN: Returns the minimum value in the array.

For example, we have a column with some numbers. If we want to get the sum of only even numbers in one cell and sum of odd numbers in another cell, we can do it by using the REDUCE function:

 

How to do Custom Mathematical Operations in an Array in Excel

Fig.1: For Even Numbers

How to do Custom Mathematical Operations in an Array in Excel

Fig. 2: For Odd Numbers

Note that the REDUCE function can only be used with the Excel 365 Dynamic Array version, as it returns an array of values rather than a single value.

 

Popular posts from this blog

Top international payment gateway transaction fee comparison (2024)

How to Manage Boot Configuration of Windows using CMD

What is Python Syntax and how to use?