[PDF]EXCEL FUNCTIONS

EASY - PEAS


© FUNCTIONS - 4,


Fa


+


ISEVEN a ISODD


= ISEVEN / (cell reference/number)


e In the first example ISEVEN and ISODD
functions are used.


e In second example | have combined ISEVEN
function with IF.


FORMULA REPRESENTATION


Number| ISEVEN Number IEVEN/ODD
Number| ISODD 65 | =IF(ISEVEN(H6)=TRUE."Even","Odd")


=ISEVEN(E2) =IF(ISEVEN(H2)=TRUE."Even" "Odd")
56 5
70 7
6
65 =ISODD(E7) 6
62 =ISODD(E8)
33
100 |


=IF(ISEVEN(H7)=TRUE,"Even","Odd")
=IF(ISEVEN(H8)=TRUE."Even"."Odd".


A


=IF(ISEVEN(H9FTRUE."Even"."Odd”)
=IF(ISEVEN(H10)=TRUE."Even" "Оаа


3
55 |=IF(ISEVEN(H4)-TRUE."Even"."Odd"
70 |=IF(ISEVEN(H5)=TRUE."Even"."Odd")
|
3


43 =ISEVEN(E3)| |8 |=IF(ISEVEN(H3)=TRUE.'Even""Odd")
BEN
Е
-коэхыу |
=ISODDES) | 13 -


ISBLANK ,
ISTEXT,
ISNUMBER,
ISERROR,


ISONTEXT


ISNUMBER


FORMULA REPRESENTATION


=ISBLANK(I8)


=ISNUMBER(I2)
=ISNUMBER(I3)
=ISNUMBER(I4}
=ISNUMBER(IS)
-ISNUMBER((16)
=ISNUMBER(I7}
-ISNUMBER(18)


=ISERROR(I2)
=ISERROR(I3)


=ISERROR(14)
=ISERROR(15)


=ISNONTEXT(I4}
=ISNONTEXT(I5}


Rosa Parks
We will fail when we fail to
try.