Voitheia sto Excel

[george1994]

Paidia thelw na kanw to parakatw:

 

Na exw p.x. 100 kelia (a1 - a100) me diaforous arithous sto kathe keli (pou mporei na einai kai idioi merikoi) kai na mporw na tous sortarw kata monous -zigous diladi...

 

1001

1045

1050

1056

1057

1079

1040

1084

 

kai na tou vgazei...

 

1001

1045

1057

1079

 

1040

1050

1056

1084

 

vevaia akoma kai na min tous sortarei, na mporei na tous ksexorisei se monous-zigous H' stin xeiroteri na dinei stin diplani stili ena aritho (p.x. 0 H' 1, gia ta mona -ziga) san apotelesma.

 

1001 0

1045 0

1050 1

1056 1

1057 0

1079 0

1040 1

1084 1

 

 

Giwrgos.

[firewalker]

Gia tin 2h pou theleis aplws na vgazei 1 h 0 pliktrologise sthn dipla stili ton kwdika ato:

 

=IF(MOD(A1;2);1;0)

[porcospino]

yeap.. mporeis kai anti gia 1 0 na baleis kateytheian

=IF(MOD(A1;2);"monos";"zygos")

 

yparxei kai i ISEVEN (bgazei TRUE gia tous zygous kai FALSE gia tous monous) kai i ISODD (kanei to antitheto.. ) alla nomizo oti an den sou douleuei thelei na egatastiseis apo to menu ERGALEIA -> PROSTHETA to ergaleio "paketo ergaleion analysis" kai meta na tin xrisimopoiiseis ws eksis...

=iseven(a1) (i =isodd(a1) )

opou tha sou epistrepsei antistoixa true h false dipla se kathe arithmo...

 

kai meta auto pou theleis na apomonoseis zygous kai monous kai na tous taksinomiseis ginetai eukola me ena filtro.. opou tou les na emfanisei mono tous monous kai meta tous kaneis taksinomisi.. kai fysika ta apotelesmata kathe filtrou mporeis na to apothikeuseis-ektyposeis ksexorista..

 

an thes boitheia gia ta filtra pes..

[george1994]

Paidia sas euxaristw, omws mou vgazei ena error, leei:

 

"The formula you are typing contains an error

 

For information about fixing common formula problems click help..."

 

Xrisimopopw to Office 2000 premium.

 

Kai grafw ton typo akrivws stin diplani stili (B1)...

[porcospino]

hmm... ta dokimases ola???

 

mipos exeis kanena lathos???