Solved Cant get this if to work...

[Number11]

I need to group the dates as follows...

Number < week old
Number >1 week but < 1 month old
Number >1 month but < 3 months old
Number >3 months but < 6 months old
Number > 6 months

=IF(AR6<7,"< 1 Week",IF(AR6<30,">1 week & < 1 month old",IF(AR6<31,">1 Month & < 3month old",IF(AR6<90,"> 3month old & < 6 Months",IF(AR6<182,"> 3month old & > 6 Months)))))))

Not working ?

 

[MajP]

See my post in this thread how to do this

Query specific times across days

Hi All! I am trying to figure out if there is a way to query a certain set time across multiple days. Example we have three shifts (Days 7AM - 3PM, Afternoons 3PM - 11PM and Nights 11PM - 7AM) I want to pull the records for each shift and count the quantity of boxes received. Right now I have...

www.access-programmers.co.uk

You would build the same table

 

[Number11]

See my post in this thread how to do this

Query specific times across days

Hi All! I am trying to figure out if there is a way to query a certain set time across multiple days. Example we have three shifts (Days 7AM - 3PM, Afternoons 3PM - 11PM and Nights 11PM - 7AM) I want to pull the records for each shift and count the quantity of boxes received. Right now I have...

www.access-programmers.co.uk

You would build the same table

Thanks i need to have this formula with excel not a database

 

[MajP]

Sorry. Did not notice what forum it was in, but I would assume that is a perfect Vlookup, but I am not an Excel expert.

 

[Number11]

Sorry. Did not notice what forum it was in, but I would assume that is a perfect Vlookup, but I am not an Excel expert.

No worries thanks anyway

 

[Number11]

think i have this working now...

=IF(AR5<7,"< 1 Week",IF(AR5<30,">1 week & < 1 month old",IF(AR5<90,">1 Month & < 3month old",IF(AR5<182,"> 3month old & < 6 Months",IF(AR5>182,"> 6 Months pls")))))

 

[Darrell]

Except if your number is 182. You may want to add an = to the last condition.

IF(AR5>=182,"> 6 Months pls")))))

 

[arnelgp]

without using IF():

=SWITCH(TRUE, AR5<7,"< 1 Week",AR5<30,">1 week & < 1 month old",AR5<90,">1 Month & < 3month old",AR5<182,"> 3month old & < 6 Months",AR5>=182,"> 6 Months pls")

 

[MajP]

I am no Excel expert, but this is a basic vlookup IMO. Those functions are overly complicated and not flexible.

 

[Isaac]

Sometimes when IF statements get hard to look at it's a nice option to create a small reference table/range and just vlookup to it.