Assignment 8 Mathematics and Logical Function Number Property

Mathematics and Logical Function

Number Property

Function uses

IF :- This function will check entire function and give the results TRUE or FALSE.

MOD:- the mod function returns the remainder of two Number after division.

ISBLANK :- this function use to check the cell is blank or not if cell is blank then it must be print TRUE otherwise FALSE.

OR :- This function use for test the multiple condition at the same time. OR returns either TRUE or FALSE. Excel OR function is a logical function.

ISEVEN :- The Excel ISEVEN function returns TRUE when a numeric value is even, and FALSE for odd numbers.

IF Function use in property cell

1st IF :- first if function check the blank value.

=IF(ISBLANK (C4)," ")

2nd IF :- 2nd if function check the value ,if this cell equal to 1 then it will be print " ODD ".

=IF(C4=1,"ODD",

3rd IF :- 3rd IF function check the value, if this cell equal to " 2 " then it will be print " Even & Prime " .

=IF(C4 = 2 , " EVEN & PRIME ",

4rth IF :- 4rth IF function check the value, if this cell equal to "3" then it will be print " ODD and Prime"

=IF(C4=3,"ODD & PRIME ",

5th IF :- 5th IF function check the value of, if this cell equal to "5" then it will be print "ODD & Prime"

=IF(C4=5," ODD & PRIME ",

6th IF :- 6th IF function check the value of, if this cell equal to "7" then it will be print " ODD and Prime " .

=IF(C4=7," ODD & PRIME ",

7th IF :- 7th IF function check the value of, if this cell equal to " Even " then it will be print " Even".

=IF(ISEVEN (C4)," EVEN ",

8th IF :- 8th IF function check the value of, if 8th IF function is depand on criteria it will be true then print " ODD " otherwise" ODD & Prime ".

MOD function use in property cell

1st MOD :- 1st MOD return the reminder of divisor by " 2 ".

=IF(OR(MOD(C4,2)=0

2nd MOD :- 2nd MOD return the reminder of divisor by " 3 ".

=MOD(C4,3)=0

3rd MOD :- 3rd MOD return the reminder of divisor by " 5 ".

=MOD(C4,5)=0

4rth MOD :- 4th MOD return the reminder of divisor by " 7 ".

=MOD(C4,7)=0

5th MOD :- 5th MOD return the reminder of divisor by " 9 ".

=MOD(C4,9)=0

Note :-

This is the assignment which is based on the number property. When I'll type any value in value cell then property of Number must get reflected that cell this Number is ODD EVEN or PRIME Number.

This is simply based on the mathematics if any number is as we know that maximum prime number is odd also and prime also example 13 is off as well as prime and 2 is even and prime so that should be also show in that cell.

Note:- Don't use number in fraction and decimal.