IF formula with multiple conditions and in between numbers

[Mehwishm04]

Hello,

I have an aging column that has several different days. I would like a IF formula that would tell me following. Below is the aging column.

0 - 30 Days

31 - 60 Days

61 - 90 Days

91 - 150 Days

Over 150 Days

Over 365 Days Over 2 Years Actual Aging 6 12 13 20 25 26 27 28 29 33 34 35 36 39 41 47 48 49 50 53 55 57 62 63 64 68 69 71 74 77 82 88 90 91 96 99 102 106 112 113 116 117 119 120 123 124 125 127 130 131 132 133 134 141 145 146 147 155 160 161 167 169 171 173 174 179 183 194 195 202 209 210 211 216 217 221 229 230 236 245 249 251 271 288 293 294 295 301 302 <tbody> </tbody><colgroup><col></colgroup>

<tbody>
</tbody><colgroup><col></colgroup>

 

[bbott]

Welcome to the board.

Assuming your data starts in A1, enter this in B2 and copy down:

=LOOKUP(A2,{0,31,61,91,151,366,731},{"0-30","31-60","61-90","91-150","over 150","over 365","over 2 years"})

 

[Mehwishm04]

Thank you soo much!!!!!

 

[bbott]

Thank you soo much!!!!!

You're welcome.