Conditional Functions

Conditional functions perform calculations on a cell or range of cells only if those cells meet a certain condition. These functions test a given range and determine if the condition is true or false before continuing.

Pada https://brainly.co.id/tugas/46559633 terdapat penjelasan prinsip dasar algoritma

Conditions can be any relational comparison, such as: 

• A3>14: Whether the value of cell A3 is larger than the number 14
• D5<=2: Whether the value of cell D5 is less than or equal to the number 2
• T47=”cheese”: Whether the value of cell T47 is “cheese”

The IF function is one type of conditional function that sets a cell to a value if the condition is true, and to another value if the condition is false.

IF(logical-test, value-if-true, value-if–false)
IF(condition, Yes, No) ==> IF(cond, Y, N)
IF(condition, value_if_true, value_if_false)

Where:

• condition: value or a logical operation that evaluates to TRUE or FALSE
• value_if_true: The value to return if the condition is TRUE (to show/display)
• value_if_false: The value to return if the condition is FALSE (to show/display)

You can also combine IF statements with AND, OR, and NOT functions. For example: 

• AND =IF(AND(Something is True, Something else is True), Value if True, Value if False)
• OR =IF(OR(Something is True, Something else is True), Value if True, Value if False)
• NOT =IF(NOT(Something is True), Value if True, Value if False)

You can also use conditional formatting to highlight cells that meet a certain condition. This can help make patterns and trends in your data more apparent. To use conditional formatting, you create rules that determine the format of cells based on their values.

• https://e115.engr.ncsu.edu/spreadsheets/conditional-functions/#:~:text=Conditional%20functions%20perform%20calculations%20on,true%20or%20false%20before%20continuing.
• https://real-statistics.com/excel-capabilities/excel-conditional-functions/
• https://real-statistics.com/excel-capabilities/excel-conditional-functions/
• https://www.datacamp.com/tutorial/conditional-functions-in-spreadsheets
• https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2
• https://corporatefinanceinstitute.com/resources/excel/excel-if-statement-guide/
• https://corporatefinanceinstitute.com/resources/excel/excel-if-statement-guide/
• https://www.perfectxl.com/academy/functions/if-function-in-excel/

Pada link https://real-statistics.com/excel-capabilities/excel-conditional-functions/ disebutkan bahwa conditional function yang terpenting adalah IF

https://real-statistics.com/excel-capabilities/table-lookup-functions/ (Baguuus!)