Solved Cant get this if to work... (1 Viewer)

Number11

Member
Local time
Today, 03:58
Joined
Jan 29, 2020
Messages
228
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

You've got your good things, and you've got mine.
Local time
Yesterday, 22:58
Joined
May 21, 2018
Messages
4,155
See my post in this thread how to do this

You would build the same table
 

Number11

Member
Local time
Today, 03:58
Joined
Jan 29, 2020
Messages
228
See my post in this thread how to do this

You would build the same table
Thanks i need to have this formula with excel not a database :(
 

MajP

You've got your good things, and you've got mine.
Local time
Yesterday, 22:58
Joined
May 21, 2018
Messages
4,155
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

Member
Local time
Today, 03:58
Joined
Jan 29, 2020
Messages
228
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")))))
 
Last edited:

Darrell

Registered User.
Local time
Today, 03:58
Joined
Feb 1, 2001
Messages
215
Except if your number is 182. You may want to add an = to the last condition.

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

arnelgp

error reading drive A:
Local time
Today, 11:58
Joined
May 7, 2009
Messages
11,183
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

You've got your good things, and you've got mine.
Local time
Yesterday, 22:58
Joined
May 21, 2018
Messages
4,155
I am no Excel expert, but this is a basic vlookup IMO. Those functions are overly complicated and not flexible.
 

Isaac

Lifelong Learner
Local time
Yesterday, 19:58
Joined
Mar 14, 2017
Messages
3,306
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.
 

Users who are viewing this thread

Top Bottom