"keaoric" wrote in
message ...

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/