0
Use this function when the value you want to assign to a cell is dependent on a logical test?
Wiki User
∙ 8y ago
The IF function.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What is the function used when a assigned value to a cell is dependent on a logical test?
if function
What function is useful when you want to assign a value to a cell cased on a logical test?
The IF function can assign a value to a cell based on a logical test.
The IF function is useful when you want to assign a value to a cell based on a logical test.?
The IF function is exactly what you need to assign a value based on a logical test, as in: =IF(A1>5,"Greater","Less" than or equals to") This will result in a cell whose value is the string "Greater" if A1 contains a value greater than 5 and "Less than or equals to" if it is not greater than 5. You can also put numbers or even formulas in the values to assign.
What is the rule that assign exactly one output value to each input value?
Function
What is the value of the dependent variable in a function is always?
It is exogenous.
What are independent variables and dependent variables in math?
Independent variables are the input value of a function (usually x) and dependent variables are the output value of the function (usually y).
A set of ordered pairs that assign to each x-value exactly one y-value is called a?
A set of ordered pairs that assign to each x-value exactly one y-value is called a function.
When function returns a value the entire function call can be assigned a variable?
AnswerYes, it can. For instance, if your function returns double you can assign the function call to a variable of type double.AnswerNo, only the returned value, of course.
What is the output variable of a function?
It is a value in the co-domain [range] of the function.
What is a dependent quantity?
the output of a function; a variable whose value depends on the value of the input.
A function may assign the same output value to two different input values?
True
What function is a logical function that returns one value if the statement is true and returns a different value if the statement is false?
isdigit is an example (see in ctype.h)
