Results 1 to 5 of 5
Thread: Excel .
Hybrid View
-
5th February 2013 19:53 #1ASRock 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, .
20Code: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