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

Number11

Member
Local time
Today, 08:55
Joined
Jan 29, 2020
Messages
607
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
Today, 04:55
Joined
May 21, 2018
Messages
8,463
See my post in this thread how to do this

You would build the same table
 

Number11

Member
Local time
Today, 08:55
Joined
Jan 29, 2020
Messages
607
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
Today, 04:55
Joined
May 21, 2018
Messages
8,463
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, 08:55
Joined
Jan 29, 2020
Messages
607
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, 08:55
Joined
Feb 1, 2001
Messages
299
Except if your number is 182. You may want to add an = to the last condition.

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

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:55
Joined
May 7, 2009
Messages
19,169
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
Today, 04:55
Joined
May 21, 2018
Messages
8,463
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
Today, 01:55
Joined
Mar 14, 2017
Messages
8,738
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