How can something be even and odd at the same time? What is the difference between this code?
'=ISEVEN($B$25) $L$1,$L$9,$L$17,$R$17,$R$9,$R$1,$L$27,$R$27,$L$30,$R$30,$L$33,$R$33
'=ISODD($B$25) $L$1,$L$9,$L$17,$R$17,$R$9,$R$1,$L$27,$R$27,$L$30,$R$30,$L$33,$R$33
Can someone tell me how to interpret these formulas below?
'=IF(AND($AF$19="D",$AV2>$W$19),1,"") $AI$2:$AI$56
'=IF(AND($AE$19="U",$AV2<$W$19),1,"") $AI$2:$AI$56
'=IF(AND($AF$32="D",$BA2>$W$32),1,"") $AN$2:$AN$36
'=IF(AND($AE$32="U",$BA2<$W$32),1,"") $AN$2:$AN$36
'=IF(AND($I$20="E",ISODD($AV3)),1,"") $AJ$2,$AJ$4,$AJ$6,$AJ$8,$AJ$10,$AJ$12,$AJ$14,$AJ$16,$AJ$18,$AJ$20,$AJ$22,$A J$24,$AJ$26,$AJ$28,$AJ$30,$AJ$32
'=IF(AND($J$20="O",ISEVEN($AV3)),1,"") $AJ$2,$AJ$4,$AJ$6,$AJ$8,$AJ$10,$AJ$12,$AJ$14,$AJ$16,$AJ$18,$AJ$20,$AJ$22,$A J$24,$AJ$26,$AJ$28,$AJ$30,$AJ$32
'=IF($A3>$L3,1,"") $R$11:$R$15,$R$3:$R$7,$R$19:$R$23 ( I know this says that is A3 is greater than L3 to put a 1 or is it add 1 in one of these cells (
$R$11:$R$15,$R$3:$R$7,$R$19:$R$23) am I correct?
'=IF($A3<$L3,1,"") $S$11:$S$15,$S$3:$S$7,$S$19:$S$23
If I have a few more formulas I want an explanation for should I open a new post or ask fora few more in this one? I want to know the best way to handle this please so i do not upset anyone or the board rules (-:
Thanks for your expertise ya'll!!