נוסחאות

IsNull
Checks if a given value is a null value
Format – isnull ( value )
IF
Conditionally executes a group of statements, depending on the value of an expression.
Format – if ( condition , case true , case false )
Avg
Returns the average value of a specified list of values
Format – avg ( value1 , value2 , value3 , … )
AvgBestOf
Returns the average of the best values according to a given number.
Format – avgbestof( number_of_best_values , value1 , value2 , value3 , … )
SumBestOf
Returns the sum of the best values according to a given number.
Format – sumbestof( number_of_best_values , value1 , value2 , value3 , … )
MinBestOf
Returns the minimum value from the best values according to a given number.
Format – minbestof( number_of_best_values , value1 , value2 , value3 , … )
Abs
Returns the absolute value of a specified number.
Format – abs ( value )
Max
Returns the maximum value of a specified list of values
Format – max ( value1 , value2 , value3 , … )
Min
Returns the minimum value of a specified list of values
Format – min ( value1 , value2 , value3 , … )
Floor
Returns the largest whole number less than or equal to the specified number.
Format – floor ( value )
Ceiling
Returns the smallest whole number greater than or equal to the specified number.
Format – ceiling ( value )
Round
Returns the number nearest the specified value.
Format – round ( value )
Sqrt
Returns the square root of a specified number.
Format – sqrt ( value )
Log
Returns the logarithm of a specified number.
Format – log ( value )
Log10
Returns the base 10 logarithm of a specified number.
Format – log10 ( value )
Sin
Returns the sine of the specified angle.
Cos
Returns the cosine of the specified angle.
Tan
Returns the tangent of the specified angle

If(IsNull([ExamA]), n, 0.35*max([Midterm],[ExamA]) + 0.65*[ExamA])