How to...

[keaoric]

Could anyone help me figure out how to do the following:

list a value in a "IF" function to = "x" or multiples of "x"

and to have any cell value of column "A1" that equals 0 make the corresponding row hidden

[David Biddulph]

"keaoric" <[email protected]> wrote in
message news:[email protected]...
>
> Could anyone help me figure out how to do the following:
>
> list a value in a "IF" function to = "x" or multiples of "x"

Not clear what you want.
=IF(MOD(A1,x)=0,"A1 is a multiple of x","A1 is not a multiple of x") if it
is the input you are trying to test, or
MROUND(your formula,x) if you want to round the output to a multiple.

> and to have any cell value of column "A1" that equals 0 make the
> corresponding row hidden

Autofilter
--
David Biddulph
Rowing web pages at
http://www.biddulph.org.uk/

[keaoric]

how do i use auto filter to do that. basically what i need to do is when the value in a certain cell column is 0, i need it to hide that row when i go to print. maybe a macro of some sort. i dont know

[keaoric]

and the mod function is what i was looking for thank you

[David Biddulph]

"keaoric" <[email protected]> wrote in
message news:[email protected]...
>
> how do i use auto filter to do that. basically what i need to do is
> when the value in a certain cell column is 0, i need it to hide that
> row when i go to print. maybe a macro of some sort. i dont know

Data/ Filter/ Autofilter
Custom
Does not equal
0
--
David Biddulph