- IvyRamsey0816165
- 조회 수 53
- 댓글 수 0
- 추천 수 0

Problem: If you have to enter multiple IF conditions, developing a good knowledge of logical operators will assist you to simplify the formula.

Strategy: When you are working with conditions, which is stuffed with And, Or, Not, Nor, True, and False. All of these words have mathematical equivalents. Understanding them enables you to make complex two-condition formulas.

eval(ez_write_tag([[336,280],'brighthub_com-box-1']));

A Boolean formula returns either TRUE or FALSE. In Fig. 590, the formula

=A2>100 will return TRUE.

You can offer many such tests. As shown in Fig. 591, this dataset has columns to find out should the technique is a unique production or in the event the region is a unique region.

You can make a calculation from your link between multiple Boolean formulas. One popular operator in Boolean logic may be the AND operator. If you want to determine D2 AND E2 is TRUE, you are able to state this like a formula.

In Boolean Logic,

togel Judi online eval(ez_write_tag([[336,280],'brighthub_com-box-3']));

' Think of each TRUE as being the primary.

' Think of each FALSE because the number 0.

' Think of each AND like a Multiplication Operator

' Think of each OR for an Addition Operator

If caused by the calculation is 0, then your fact is FALSE. If the consequence of the calculation is non-zero next the solution is TRUE.

Here is definitely an example, as shown in Fig. 592:

Plain language: The bonus is paid should the sale is >100 and also the method is ABC.

Excel: =(A2>100)*(B2='ABC')

A=105 B=ABC: TRUE * TRUE= 1*1=1=TRUE

A=92 B=ABC: FALSE * TRUE= 0*1=0=FALSE

A=85 B=DEF: FALSE * FALSE= 0*0=0=FALSE

eval(ez_write_tag([[336,280],'brighthub_com-box-2']));

A=101 B=DEF: TRUE * FALSE= 1*0=0=FALSE

Here would be the logic rules for AND operators and OR operators.

AND OR

TRUE*TRUE=TRUE TRUE+TRUE=TRUE

TRUE*FALSE=FALSE TRUE+FALSE=TRUE

FALSE*TRUE=FALSE FALSE+TRUE=TRUE

FALSE*FALSE=FALSE FALSE+FALSE=FALSE

Here is the one other example to see.

Plain language: Bonus is paid for selling anything over $100.00 or sales of DEF product.

Excel: =(A2>100)+(B2='DEF'), as shown in Fig. 593.

Sales Product S ales>100 I tem=DEF Bonus Calculation

80 DEF FALSE TRUE =0+1=1=TRUE

105 DEF TRUE TRUE =1+1=2=TRUE

90 ABC FALSE FALSE =0+0=0=FALSE

110 ABC TRUE FALSE =1+0=1=TRUE

Using the above mentined rules, it is possible to write complex teams of Boolean logic. The formula in Fig. 594 would pay a $25 bonus for everyone West region sales of jackets at any price or caps above $50.

Summary: Excel has the AND and OR functions. However, having the ability to use Boolean terms as being the first parameter of your IF statement makes for more advanced calculations.

Functions Discussed: =IF(); =AND(); =OR()

See all Microsoft Excel tips

IP *.73.79.193
Strategy: When you are working with conditions, which is stuffed with And, Or, Not, Nor, True, and False. All of these words have mathematical equivalents. Understanding them enables you to make complex two-condition formulas.

eval(ez_write_tag([[336,280],'brighthub_com-box-1']));

A Boolean formula returns either TRUE or FALSE. In Fig. 590, the formula

=A2>100 will return TRUE.

You can offer many such tests. As shown in Fig. 591, this dataset has columns to find out should the technique is a unique production or in the event the region is a unique region.

You can make a calculation from your link between multiple Boolean formulas. One popular operator in Boolean logic may be the AND operator. If you want to determine D2 AND E2 is TRUE, you are able to state this like a formula.

In Boolean Logic,

togel Judi online eval(ez_write_tag([[336,280],'brighthub_com-box-3']));

' Think of each TRUE as being the primary.

' Think of each FALSE because the number 0.

' Think of each AND like a Multiplication Operator

' Think of each OR for an Addition Operator

If caused by the calculation is 0, then your fact is FALSE. If the consequence of the calculation is non-zero next the solution is TRUE.

Here is definitely an example, as shown in Fig. 592:

Plain language: The bonus is paid should the sale is >100 and also the method is ABC.

Excel: =(A2>100)*(B2='ABC')

A=105 B=ABC: TRUE * TRUE= 1*1=1=TRUE

A=92 B=ABC: FALSE * TRUE= 0*1=0=FALSE

A=85 B=DEF: FALSE * FALSE= 0*0=0=FALSE

eval(ez_write_tag([[336,280],'brighthub_com-box-2']));

A=101 B=DEF: TRUE * FALSE= 1*0=0=FALSE

Here would be the logic rules for AND operators and OR operators.

AND OR

TRUE*TRUE=TRUE TRUE+TRUE=TRUE

TRUE*FALSE=FALSE TRUE+FALSE=TRUE

FALSE*TRUE=FALSE FALSE+TRUE=TRUE

FALSE*FALSE=FALSE FALSE+FALSE=FALSE

Here is the one other example to see.

Plain language: Bonus is paid for selling anything over $100.00 or sales of DEF product.

Excel: =(A2>100)+(B2='DEF'), as shown in Fig. 593.

Sales Product S ales>100 I tem=DEF Bonus Calculation

80 DEF FALSE TRUE =0+1=1=TRUE

105 DEF TRUE TRUE =1+1=2=TRUE

90 ABC FALSE FALSE =0+0=0=FALSE

110 ABC TRUE FALSE =1+0=1=TRUE

Using the above mentined rules, it is possible to write complex teams of Boolean logic. The formula in Fig. 594 would pay a $25 bonus for everyone West region sales of jackets at any price or caps above $50.

Summary: Excel has the AND and OR functions. However, having the ability to use Boolean terms as being the first parameter of your IF statement makes for more advanced calculations.

Functions Discussed: =IF(); =AND(); =OR()

See all Microsoft Excel tips