Microsoft Office Forums - View Single Post - Formula to return a value of 1,2,3 or based on a set criteria

Thread: Formula to return a value of 1,2,3 or based on a set criteria

View Single Post

Old

06-01-2017, 12:59 PM

NBVC

NBVC is offline

NBVC uses Windows 7 64bit

Windows 7 64bit NBVC uses Office 2007

NBVC uses Office 2007

Office 2007

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Does this work?

=LOOKUP(DATEDIF(TODAY(),L5,"m"),{0,4,6,12},{1,2,3, 4})

Reply With Quote