"if even" function

H

Hugh Stanley

Anyone know something like an "if even" function?

I'm interested in if a grid is even, that a certain function be
performed on an adjoining grid, if odd, something else...

Thanks,

- Hugh -
 
R

RagDyeR

In Help lookup "ISEVEN".

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Anyone know something like an "if even" function?

I'm interested in if a grid is even, that a certain function be
performed on an adjoining grid, if odd, something else...

Thanks,

- Hugh -
 
P

Pete_UK

Hugh,

I would suggest you use the term "cell". There is a function ROW()
which returns the row number that the cell is on, and there is also a
function MOD( ) which gives the remainder after division. So, the
formula:

=IF(MOD(ROW(),2)=1,"odd","even")

would enable you to do something instead of "odd" for odd-numbered rows
and do something else instead of "even" for even-numbered rows.

Hope this helps.

Pete
 
Top