• 세계를 향한 끊임없는 기술창조정신! Global CT 우리는 아이엠씨티입니다.
  • 세계를 향한 끊임없는 기술창조정신! Global CT 우리는 아이엠씨티입니다.
  • 세계를 향한 끊임없는 기술창조정신! Global CT 우리는 아이엠씨티입니다.
  • 세계를 향한 끊임없는 기술창조정신! Global CT 우리는 아이엠씨티입니다.
  • 세계를 향한 끊임없는 기술창조정신! Global CT 우리는 아이엠씨티입니다.
  • 세계를 향한 끊임없는 기술창조정신! Global CT 우리는 아이엠씨티입니다.

고객지원

  • 공지사항 & 뉴스
  • 문의상담
  • 연락처안내
2017.08.12 12:15:35
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
오시는길 문의하기 ENGLISH Korean 관리자 로그인