GT

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

Syntax:

GT(numberOne, numberTwo)

You could use ">" instead, either way works.

Example:

If numberOne contains 1 and numberTwo contains 2:

GT(1, 2) or 1 > 2

returns FALSE

If numberOne contains 3 and numberTwo contains 2:

GT(3, 2) or 3 > 2

returns TRUE

numberOne:

numberTwo:

Result:

FALSE

Application:

Student Grading System

Imagine a teacher who wants to quickly identify which students have scored above a certain threshold on a test to determine who qualifies for an advanced study group. The qualifying score is 85. The GT function is the perfect tool for this task.

We'll use a table with the student's name, their test score, and the result of the GT function to see if they qualify. The function we'll apply is:

GT(Test Score, 85)

This function will return TRUE if the student's test score is greater than 85, and FALSE otherwise.

	Student Name	Test Score	Qualifying for Advanced Group? (GT(Test Score, 85))
	A	B	C
1	Alice	92	TRUE
2	Bob	78	FALSE
3	Charlie	85	FALSE
4	Diana	95	TRUE
5	Eve	84	FALSE
6	Frank	88	TRUE

Explanation:

Alice: Her score of 92 is greater than 85, so the GT function returns TRUE. She qualifies.
Bob: His score of 78 is not greater than 85, so the GT function returns FALSE. He does not qualify.
Charlie: His score of 85 is equal to 85, not greater than. Therefore, the GT function returns FALSE. He does not qualify.
Diana: Her score of 95 is greater than 85, so the GT function returns TRUE. She qualifies.
Eve: Her score of 84 is not greater than 85, so the GT function returns FALSE. She does not qualify.
Frank: His score of 88 is greater than 85, so the GT function returns TRUE. He qualifies.