Assignment 11 Logical Function Even, Odd value and divided by 5

 

Assignment 11

Logical Function

Even, Odd value and divided by 5

Function Use

CONCATENATE:- This function helps to combine "text" of 2 different cell into 1 cell.

IF :- The IF function can perform a logical test and returns a "TRUE" or "FALSE".

ODD :- The ODD function always rounds up to the odd integer, skipping even integer along the way.

MOD :- The Excel MOD function returns the remainder of two numbers after division. For example, MOD(10,3) = 1

Function evaluate in

=CONCATENATE(IF(ODD(D9)=D9,"ODD","Even"),IF(MOD(D9,5)=0,"Divided by 5","Not divided by 5"))

CONCATENATE:- This function helps to combine "text" of 2 different cell into 1 cell.

IF :- This function work in that process test to the logical criteria if it is true according that criteria then it will be print true that you specified text otherwise false that you specified text in false.

ODD :- it give nearest greater then odd value of given value.

MOD :- Return the reminder of divisor.

Note:-

This assignment we want to know about the property a number should be natural number like 1,2,3,4....99999.

Whenever I'll type any number or value in value cell the result should show like that is even number or odd number.

One more thing is any number is divisible by 5 then that much show in yellow cell example are given below -

102 is Even

103 is Odd

100 is Even

115 is Odd and Divided by 5 also