answersLogoWhite

0

You need to use the OR function. You could have something like this:

=OR(A2>5,A4>10,A6>20)

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

A function prime that returns if its argument is a prime no or returns zero?

prime number


Which logical function returns a true result only when all its arguments are true?

The AND function.


What is a minimum function?

The minimum function is the function that takes two arguments and returns the smallest of the two. Alternatively the function can take any finite amount of arguments and return the smallest.


What are the conditional logic functions in computer applications?

Not sure what you are asking here, but here is my best guess.COMPUTER PROGRAMMING APPLICATIONS:IF - If a condition exists, do something, if not, do something else.CASE - If a condition equals CASE1 do this; if CASE2 do this; etc.WHILE - If a condition remains, keep doing something until the condition changes.EXCEL:AND(logical1,logical2,...) - tests whether the logical arguments are TRUE or FALSE. If they are all TRUE, the AND function returns TRUE to the cell. If any are FALSE, the AND function returns FALSE.IF(logical_test,value_if_true,value_if_false) - tests whether the logical_test expression is TRUE or FALSE. If TRUE, the IF function returns the value_if_true argument. If FALSE, the IF function returns the value_if_false argument.IFERROR(value,value_if_error) - tests whether the value expression is an error. IFERROR returns value_if_error if the expression is an error, or value of the expression if it is not an error.NOT(logical) - tests whether the logical argument is TRUE or FALSE. If TRUE, the NOT function returns FALSE. If FALSE, the NOT function returns TRUE.OR(logical1,logical2,...) - tests whether the logical arguments are TRUE or FALSE. If any are TRUE, the OR function returns TRUE. If all are FALSE, the OR function returns FALSE.FALSE() - takes no argument and simply enters logical FALSE in its cell.TRUE() - takes no argument and simply enters logical TRUE in its cell.


Sample program in c plus plus with parameter?

C++ doesn't have parameters it has arguments, both formal and actual. Actual arguments are the arguments you pass to a function. Formal arguments are the arguments used by the function and which are treated as local variables within the function body. Formal arguments always fall from scope when the function returns. In order for a function to make changes to the actual argument you you can either return the formal argument by value and assign the function to the actual argument upon return, or you can pass the argument by reference. In the former case, the returned value is temporary. If the function is not assigned to the actual argument, the temporary value falls from scope. In the latter case, the actual and formal arguments both refer to the same object through separate names (aliases). Thus any operations performed on the formal argument will affect the actual argument (they are one and the same object). Example: // Forward declarations. int byval (int); void byref (int&); int main() { int actual = 42; byval (actual); // The byval formal argument is no longer in scope. // Although a temporary value of 84 was returned, // it wasn't assigned to anything and is no longer // available. // The actual argument still has the value 42. actual = byval (actual); // The byval formal argument is no longer in scope, // however, its value was returned and assigned // to the actual argument. // The actual argument now has the value 84. byref (actual); // The formal argument and the actual argument are // one and the same argument. // The actual argument now has the value 42. } int byvalue(int formal) { formal *= 2; return formal; } // The formal argument no longer exists, but its value // was pushed into the function's return address. That // value will cease to exist unless the caller immediately // assigns the function's return value to a variable. void byref(int& formal) { formal /= 2; } // The formal argument no longer exists and nothing // was pushed onto the function's return address. // However, formal was just an alias for the actual // argument, thus the actual argument has already // been updated.


What are the different types of function in c plus plus programming?

There are five types of functions and they are:Functions with no arguments and no return values.Functions with arguments and no return values.Functions with arguments and return values.Functions that return multiple values.Functions with no arguments and return values.Functions with no arguments and no return value.A C function without any arguments means you cannot pass data (values like int, char etc) to the called function. Similarly, function with no return type does not pass back data to the calling function. It is one of the simplest types of function in C. This type of function which does not return any value cannot be used in an expression it can be used only as independent statement.Functions with arguments and no return value.A C function with arguments can perform much better than previous function type. This type of function can accept data from calling function. In other words, you send data to the called function from calling function but you cannot send result data back to the calling function. Rather, it displays the result on the terminal. But we can control the output of function by providing various values as arguments. Functions with arguments and return value.This type of function can send arguments (data) from the calling function to the called function and wait for the result to be returned back from the called function back to the calling function. And this type of function is mostly used in programming world because it can do two way communications; it can accept data as arguments as well as can send back data as return value. The data returned by the function can be used later in our program for further calculations. Functions with no arguments but returns value.We may need a function which does not take any argument but only returns values to the calling function then this type of function is useful. The best example of this type of function is "getchar()" library function which is declared in the header file "stdio.h". We can declare a similar library function of own. Functions that return multiple values.So far, we have learned and seen that in a function, return statement was able to return only single value. That is because; a return statement can return only one value. But if we want to send back more than one value then how we could do this? We have used arguments to send values to the called function, in the same way we can also use arguments to send back information to the calling function. The arguments that are used to send back data are called Output Parameters.It is a bit difficult for novice because this type of function uses pointer


How do you Write a function prototype for a function named printStars that accepts no arguments and returns no data?

void printStarts (void);


What is a variable that is used within a function?

If the variable is declared within the function body, it is a local variable, one that is local to the function. Local variables fall from scope when the function returns, they are only accessible within the function. However, local variables can be returned by value, which creates an automatic variable that is returned to the caller. If the caller does not store the return value, the automatic variable falls from scope when the expression containing the function call ends. However, the expression may evaluate the return value without storing it. Note that functions cannot return local variables by reference since the local variable falls from scope when the function returns. If the variable is passed as an argument to the function, then the variable is a parameter of the function. Arguments may be passed by value or by reference, depending upon the function signature. Passing by value means the function parameter is a copy of the argument (if the argument is an object, the object's copy constructor is invoked automatically). Thus any changes made to the parameter within the function are not reflected in the argument that was originally passed, and the parameter will fall from scope when the function returns. However, the value of the parameter can be returned as previously explained. Passing by reference means the function parameter refers directly to the argument that was passed. Thus any changes made to the parameter are reflected in the argument. Parameters that are declared as constant references assure the caller that the reference's immutable members will not be altered by the function. If the parameter is a non-const reference but the caller does not wish changes to be reflected in the argument, the caller should pass a copy of the argument instead.


Does a function that takes a value or values and performs an operation return a result to the caller?

Not necessarily. A function that accepts one or more arguments may process those arguments but need not return any value to the caller. In this case the function simply returns void.


How would you write a function prototype for a function named calcAreaReact that accepts two arguments width and length and returns the area.?

double calcAreaRect (double a, double b);


Design a function named max that accepts two integer values as arguments and returns the value that is greater of the two For example if 7 and 12 are passed as arguments to the function the function?

The function already exists in PHP and is even called max(); Otherwise use: function max ($one, $two) { return $one > $two ? $one : $two; }


Write a function prime that return 1 if its argument is a prime and returns 0 otherwise?

#include<stdio.h> #include<conio.h>main() { }