Filtering with IF statement

  • Thread starter Thread starter Eleonora
  • Start date Start date
E

Eleonora

Hi,

I would like to mark a cell using the IF like:

A B C D

Number 0 - 30 31 - 60 61 - 90

15 X
25 X
32 X
45
61 X

EX: IF(A1<31,"X","") this works for the B column but I cannot get C and D
to work.
Can you pls help.
TIA
Elena
 
Hi Eleonora,

Perhaps you want the formulas (and use of fill-handle to fill down)
B1: =IF(A1<31,"X","") --
C1: =IF(AND(A1>30,A1<=60),"X","")
D1: =IF(AND(A1>60,A1<=90),"X","")

If you are looking for a range for filtering use, you might use
just the single column:
B1: =TRUNC(A1/10) * 10


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top