स्प्रेडशीट में किसी भी तीन निर्णय लेने के फंक्शन का सिंटेक्स और उदाहरण दें
Answers
Answer:
IF, IFERROR, AND are the three decision-making functions.
Step-by-step explanation:
The three decision-making functions are as follows :
1) IF: verifies whether a condition is met or not. If the condition is met returns true. If the condition is not met returns false. The syntax : =IF(condition,[value if true],[value if false]). Example : IF(ISNUMBER(100),"Yes","No"). If the number is 22 it will return Yes.
2) IFERROR: returns the expression value if no error occurs otherwise returns the error value. Syntax : =IFERROR(expression,[error value]). Example : =IFERROR(1/0,"Divide by zero error"). It will return the text "Divide by zero error".
3) AND : checks multiple condtions and returns true if all the conditions are true. Syntax : =AND(condition1,condtion2). Example : =AND(1>0,2<5). As both the conditions are true it will return True.
Answer:
Step-by-step explanation:
1) IF: verifies whether a condition is met or not. If the condition is met returns true. If the condition is not met returns false. The syntax : =IF(condition,[value if true],[value if false]). Example : IF(ISNUMBER(100),"Yes","No"). If the number is 22 it will return Yes.
2) IFERROR: returns the expression value if no error occurs otherwise returns the error value. Syntax : =IFERROR(expression,[error value]). Example : =IFERROR(1/0,"Divide by zero error"). It will return the text "Divide by zero error".
3) AND : checks multiple condtions and returns true if all the conditions are true. Syntax : =AND(condition1,condtion2). Example : =AND(1>0,2<5). As both the conditions are true it will return True.