How to...

K

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 th
corresponding row hidde
 
D

David Biddulph

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

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

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
Click to expand...

Autofilter
 
K

keaoric

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

David Biddulph

keaoric said:
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
Click to expand...

Data/ Filter/ Autofilter
Custom
Does not equal
0
 
Top