What does the HYPGEOMDIST function do in Excel 2010

if function.

if(and(f3="Yes",g3="Yes",h3="Yes"),"Done","Not finished")

The meaning of this function is that if (both satisfy (f3="Yes",g3="Yes",h3="Yes"Then it is"Done", otherwise it is"Not finished"。

There is also a case where one condition is met, that is, if(or(f3="Yes",g3="Yes",h3="Yes"),"Done","Not finished")。

sumifs multi-condition summation.

The problem is shown in the figure below.

function=sumifs(Order Schedule!) H3:H636, Order Statement!

E3: E636, Order Schedule! E7, Order Schedule!

b3:b636,"<=2012-12-31", Order Schedule! b3:

b636,">=2012-1-1")

sumifs (Total Sales, Condition Area 1, Condition 1 (MS Office Advanced Applications), Condition Area 2, Condition 2 (2012), Condition Area 3, Condition 3 (2012)).

vlookup (d3, Table 2, 2, 0).

vlookup is an autofill function, which is interpreted as a condition in cell d3, and table 2 has a corresponding relationship with d3. What needs to be populated is column 2 of Table 2. The last 0 is the default.

mid truncation function.

if(mod(mid(c2，17，1),2)=1，"Male","Female")

If (divided by (truncated (cell C2, starting at 17 bits, truncated by two digits), 2) equals 1, then it is "male", otherwise it is "female".

This function should be translated from the innermost function outwards. i.e. mid--mod--if

Functions. Functions.

Functional functions (the probability is very high, I got it today).

Functions are mainly these.

There are no errors, but not comprehensively.

Also used are sumif, sumifs, round, left, and weekday

Use the normsinv function in Excel 2010 to calculate the inverse function that returns the standard normal cumulative distribution function.

The expression of the normsinv function is: normsinv(probability). where probability represents the probability value of the normal distribution.

If any of the arguments are textual, the function gammainv returns an incorrect value!.

If probability < 0 and probability > 1, the function gammainv returns the error value num!.

If alpha 0 or beta 0, the function gammainv returns an error value of num!.

If a probability value is given, gammainv solves for the numeric value x using gammadist(x, alpha, beta, true) =probability. Therefore, the accuracy of the gammainv depends on the accuracy of the gammadist. Gammainv uses iterative search techniques.