GTE


Returns TRUE if the first number is greater than or equal to the second number, otherwise FALSE

Syntax:

GTE(numberOne, numberTwo)


Example:

If numberOne contains 1 and numberTwo contains 2:

GTE(1, 2)

returns FALSE


If numberOne contains 2 and numberTwo contains 2:

GTE(2, 2)

returns TRUE


If numberOne contains 3 and numberTwo contains 2:

GTE(3, 2)

returns TRUE


numberOne:


numberTwo:


Result:

FALSE

Application:

Student Grade Evaluation


Imagine a teacher needs to determine which students have passed a test. The passing score is 70.


The "GTE function" would be used to evaluate each student's score against the passing score.

  • Function Name: GTE(student_score, passing_score)
  • Purpose: To check if a student's score is greater than or equal to the passing score.
  • Returns: TRUE if the student has passed, FALSE if they have not.


Here is the table of students, their scores, and the result of the GTE evaluation:

Student Name

Student Score

Passing Score

GTE(Student Score, Passing Score)

Result

A
B
C
D
E
1
Alex
85
70
GTE(85, 70)
TRUE (Passed)
2
Brenda
70
70
GTE(70, 70)
TRUE (Passed)
3
Charlie
68
70
GTE(68, 70)
FALSE (Failed)
4
Diana
92
70
GTE(92, 70)
TRUE (Passed)
5
Edward
55
70
GTE(55, 70)
FALSE (Failed)

In this example, the GTE function acts as a pass/fail switch.

  • For Alex, 85 >= 70 is TRUE.
  • For Brenda, 70 >= 70 is TRUE.
  • For Charlie, 68 >= 70 is FALSE.




This page is protected by Google reCAPTCHA. Privacy - Terms.
 
Built using Zapof