Results 1 to 5 of 5
Hybrid View
-
5th February 2013 19:53 #1
Öåëî÷èñëåíî äåëåíèå â Excel èëè íåùî òàêîâà.
Çäðàâåéòå. Äàñêàëèöàòà íè äàäå çàäà÷êà äà âúâåäåìå 20 ÅÃÍ-òà â Excel è ïîñëå â ñúñåäíàòà êîëîíêà äà ñå èçïèøå "0" çà ìúæ è "1" çà æåíà. Ïðåäïîñëåäíàòà öèôðà îò ÅÃÍ-òî ïîêàçâà ïîëà - àêî å ÷åòíî ÷èñëî, òî èíäèâèäúò å îò ìúæêè ðîä, àêî å íå÷åòíî å îò æåíñêè ðîä. Äåìåê ïî íàêàêúâ íà÷èí òðÿáâà äà ñå ðàçäåëè òàÿ öèôðà çà äà âèäè äàëè å ÷åòíà è ñúîòâåòíî â ñúñåäíàòà êîëîíêà äà ñå èçïèøå 0 èëè 1. Ïèòàì ãîñïîæàòà - ñ öåëî÷èñëåíî äåëåíèå ùå ñòàíå ëè, òÿ ìè êàçà - äà. Ïèòàõ ÿ äàëè ùå ñòàíå ñ MOD, òÿ ïàê êàçà äà. Å 40 ìèíóòè ñè áëúñêàõ ãëàâàòà êàê äà ãî íàïðàâÿ, íî ðåçóëòàò - íèêàêúâ. Ïðèëàãàì è ôàéëà è áëàãîäàðÿ ïðåäâàðèòåëíî.
EGN.rarASRock B450M Pro4 / 5700X@4.5GHz / MSI RX 6600 XT Mech 2X / be quiet! Dark Rock 4 / 2x16GB FlareX 3200MHz CL16 / FSP Hydro G Pro 1000W / Samsung Odyssey G5 S27AG50
-
5th February 2013 21:39 #2
Ôóíêöèÿ ISODD
Ïîñëå IF/ELSECode:Îïèñàíèå Âðúùà TRUE, àêî ÷èñëî å íå÷åòíî, èëè FALSE, àêî ÷èñëî å ÷åòíî.
Îòíå ìè êúì 20 ñåê äà ãî íàïèøà ñ åäèí ïðúñò â ãîîãëåòîCode:Syntax The syntax for the nesting the IF function is: IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 )) This would be equivalent to the following IF THEN ELSE statement: IF condition1 THEN value_if_true1 THEN value_if_true2 ELSE value_if_false2 END IF
Desktop - Ryzen 5 5600X, Asus Prime B500-Plus, Asus Strix RX 6600XT OC, 2x16GB Crusial Ballistix DDR4-3200, Corsair MP600 500GB M2.Gen 4.0x4, SEASONIC Focus Plus SSR-650FX, Corsair Carbide 270R, HP Z24i
-
6th February 2013 09:35 #3Registered User
Join Date: Aug:2009
Location: Ñîôèÿ
Posts: 265
Code:=IF(MOD(MID(B3;9;1);2)=0;"0";"1")
-
6th February 2013 16:04 #4À òîâà ïðàâè ïðîâåðêà è àêî íÿìà âúâåäåíî ÅÃÍ, íå èçïèñâà íèùî.Code:
=IF(ISODD(MID(B3,9,1)),1,0)
Code:=IF(B3,IF(ISODD(MID(B3,9,1)),1,0),"")
Desktop - Ryzen 5 5600X, Asus Prime B500-Plus, Asus Strix RX 6600XT OC, 2x16GB Crusial Ballistix DDR4-3200, Corsair MP600 500GB M2.Gen 4.0x4, SEASONIC Focus Plus SSR-650FX, Corsair Carbide 270R, HP Z24i
-
6th February 2013 19:33 #5
Áëàãîäàðÿ.
ASRock B450M Pro4 / 5700X@4.5GHz / MSI RX 6600 XT Mech 2X / be quiet! Dark Rock 4 / 2x16GB FlareX 3200MHz CL16 / FSP Hydro G Pro 1000W / Samsung Odyssey G5 S27AG50




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè