answersLogoWhite

0

The If function has the following format: =IF(<Condition> , <True value> , <False value>)

The Condition is the problem to be evaluated. eg. Amount of wages someone earned to determine their tax bracket.

The True value is the action to be taken if the given condition is fulfilled. This may be to add a value to something or multiply a value by something etc.

The False value is the action to be taken if the condition is not fulfilled.

The three elements must be separated by commas.

In any given case, either the False or True actions can be done, as a condition is either True or False, but never both.

As an overall example, if in the cell B3 you had a value which must be multiplied by 10 if it is over 100 or else multiplied by 5 the function would be:

=IF(B3>100, B3*10,B3*5)

Breaking this down: B3>100 = Condition. B3*10 = True value. B3*5 = False value.

User Avatar

Reed Keeling

Lvl 10
2y ago

What else can I help you with?

Related Questions

Why is syntax important in VB Scripting?

The syntax of function (I hope that Function is related to function syntax):1. Helps you in using or calling the function even though you do not know the whole implementation inside it2. Helps the compiler in performing the cross check of the function called used in code, as it checks if the syntax matches with used one or not.3. Helps in solving compiler error to some extent.I think it is the 'function prototype' what you think of. Syntax is a set of rules that formally describe a programming language.


What is the syntax of function?

Function declaration, definition, or calling? Pick one.


The rules for constructing a function can be referred to as the function's?

Syntax refers to the rules for constructing a function.


What is the syntax of the AVERAGE function in Microsoft Excel?

The Average function can use numbers, cells or ranges or a mix of these. IT can take up to 255 values. The general syntax is: =AVERAGE(number1, [number2], ...)


What is written in the correct syntax in Excel?

When functions are used, they must follow their designated structure, which is the syntax. If the syntax is not followed, the function will not work. The same is the case if VBA is being used to write code for the worksheet.


What is the function and syntax of printf statement?

it's not a statement, it's a function: len= printf (format, ...more-parameters...);


What is an object function?

A function object is a computer programming construct allowing an object to be invoked or called as if it were an ordinary function, usually with the same syntax ...


What errors do function prototype help prevent?

Syntax errors and prototype errors.


How do you create function in php?

they're called user-defined functions, this is the syntax: function the_user_defined_name() { the code you want here }


What is the syntax for math.h function?

#include double y, x;y= sin (x);


What are the basic syntax of c program?

You have to be more specific. What part of C syntax? Do you want the syntax for outputing a number or sentence, do you want to syntax for creating a array, struct, a user defined function or what? #include iostream using namespace std; int main { cout &lt;&lt; "Hello World!" &lt;&lt; endl; return 0; };


What is the syntax for calculating eigenvalues and eigenvectors in MATLAB in a specific order using the 'eig' function?

To calculate eigenvalues and eigenvectors in MATLAB using the 'eig' function, the syntax is as follows: eigenvectors, eigenvalues eig(matrix) This command will return the eigenvectors and eigenvalues of the input matrix in a specific order.