Nt1310 Unit 6 Research Paper

NOT function is a logical function in Excel. It returns the opposite value of a given logical value in the formula. This function helps to check that one value is equal to another value or not. If we put TRUE in this function it returns False, it we put False then it returns True. We can use either TRUE or FLASE value in this function at a time. Not function can be used to check if the certain condition is met or not.
Formula and Explanation
There is only one parameter in the NOT function that is logical value.
Compulsory Parameter:
 Logical: it is numeric value 0 is considered as false and rest of the values considered as true.
Logical is an expression that either calculates the TRUE or FALSE. If will return TRUE if the expression is FALSE

NOT function
Values Logical test
98 TRUE
140 FALSE
145 FALSE
103 FALSE
100 TRUE
99 TRUE
93 TRUE
176 FALSE
187 FALSE

166 FALSE

=NOT(B4>100) and output will be TRUE
Example 2:
Let consider one another example wherein we have to exclude the color combination of Red Blue from the set of Toys data then we can use the NOT function to filter out this combination.
ID Toy Name Color Price Check for No Red blue color
1 Baloo Red 500 TRUE
2 Panda White 250 TRUE
3

Mickey
Mouse Red 150 TRUE
4 Donald Duck Slate Black 200 TRUE
5 Rabbits Red Blue 450 FALSE
6 Parrot Green 200 TRUE
7 Goofy Black 350 TRUE
8 Bear Red Blue 550 FALSE

=NOT(D16="Red Blue") output will be True because here the color is “Red”.
Example 3:
Let take an example considering the employee data wherein we have to find out the bonus amount for employees who did extra task and no bonus for whom did not perform extra task and employees get
100 Rs. for each extra task done them. Then we can achieve this by using NOT

As it will first check for blank entry in cell if not blank then it will multiple the extra task and 100 to calculate the extra bonus unlocked by the employee.

Example 4:
Suppose we have to perform a check on colors such as for the below example we have to filter out the toy name having the color Blue or Red r from the given set of data. Then here we can perform a logical test by using NOT function to achieve the required set of result.
Check for Red Or Blue Color
Color Name Quantity
Fla
g
Orange Mickey Mouse 200 x
Blue Donald Duck 350
Pink Rabbits 150 x
Black Parrot 120 x
Blue Goofy 350
Red Bear 250
White Ballu 200 x
Yellow Kungfu Panda 150 x

=IF(NOT(OR(I4="red",I4="blue")),"x","") and output will be x here.
First this will check the condition if the color column contains any toy with color blue or red if the condition is true then it will return blank as output if not true then it will return x as output.
Things to remember about the NOT