How to...
 

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


--
keaoric
------------------------------------------------------------------------
keaoric's Profile: http://www.excelforum.com/member.php...o&userid=36139
View this thread: http://www.excelforum.com/showthread...hreadid=559134

How to...
 

"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/

How to...
 

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
------------------------------------------------------------------------
keaoric's Profile: http://www.excelforum.com/member.php...o&userid=36139
View this thread: http://www.excelforum.com/showthread...hreadid=559134

How to...
 

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


--
keaoric
------------------------------------------------------------------------
keaoric's Profile: http://www.excelforum.com/member.php...o&userid=36139
View this thread: http://www.excelforum.com/showthread...hreadid=559134

How to...
 

"keaoric" wrote in
message ...

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