I don t understand the usage and meaning of execl data and formulas, can anyone help me explain it?

Enter in i3 = working hours * hourly wage. School Supplies Change the text to the cell where the corresponding data is in.

Suppose the column numbers corresponding to this string of text are a, b, etcg, then in i3 input =a3*b3-c3-d3-e3-f3-g3, select cell i3, mouse the mouse in the lower right corner of i3, when the cursor changes to a cross, hold down and drag it to cell i6.

i1=(a1*b1-c1-d1-e1-f1-g1-h1)

I don't know if that's what you mean.

=if(and(d37:f37),if(c37,"Linearity is acceptable","This gage is not suitable for linear analysis"),"Linearity is unacceptable")

This is a two-layer nest of an if function.

and(d37:f37), which is equivalent to and(d37=true,e37=true,f37=true). This means that d37:f37 must be both eligible (i.e., not 0 at the same time).

When d37:f37 are both eligible, return "if(c37,"Linearity is acceptable","This gage is not suitable for linear analysis"Otherwise, return"Linearity is unacceptable"。

After the first condition is met, it is further determined whether C37 is true (not equal to 0), and if yes, it is returned"Linearity is acceptable"；No returns"This gage is not suitable for linear analysis"

=if(and(h9="",i9="",j9="",k9=""),"",if(or(c9="",e9="",d9=""),"",if(((max(h9:k9)-(f9+g9)/2))/((d9-e9)/2))>0,((max(h9:k9)-(f9+g9)/2))/((d9-e9)/2)),0)))

If the four cells of H9, I9, J9, K9 are null values, the formula returns null values, if one cell in the three cells of C9, E9, D9 is in empty format, the formula returns null values, if the maximum value in the H9 to K9 cell range minus the value of F9 plus the sum of G9 divided by 2 and divided by the difference of D9 minus E9 divided by 2 is greater than 0, then calculate the value of the maximum value in the H9 to K9 cell range minus the sum of F9 plus G9 divided by 2 and divided by D9 minus the difference of E9 divided by 2, Otherwise, a value of 0 is returned.

That is, in addition to the two conditions that return a null value, the third condition is to return 0 when the value of the equation ((max(h9:k9)-(f9+g9) 2)) ((d9-e9) 2)) is negative, otherwise the value is the value of this formula.

formula""It means an empty cell or a null value.

The formula can be shortened as:

if(or(countif(h9:k9,"")=4,countif(c9:e9,"")>0),"",max((max(h9:

k9)-(f9+g9)/2)/((d9-e9)/2),)

Assuming the data is in cell A1, E1 input = if(A1=B1,C1*,C1).

Input=if(a2<>b2,-c2,c2*

See the attached drawings for example.

Suppose that 1,2 is column a, column b, gray is c, and yellow is d

Enter in d1, =if(a1=b1,,-1*c1).

Suppose y is known to have value c in a1, a value is entered in b1, and the result of b is shown in c1.

Enter =(b1+) in c1