Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formula to return a value of 1,2,3 or based on a set criteria
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2017, 01:56 PM
NBVC's Avatar
NBVC NBVC is offline Formula to return a value of 1,2,3 or based on a set criteria Windows 7 64bit Formula to return a value of 1,2,3 or based on a set criteria Office 2007
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Like this:



=LOOKUP(DATEDIF(L5,TODAY(),"m"),{0,4,6,12},{1,2,3, 4})
Reply With Quote
  #2  
Old 06-01-2017, 02:18 PM
Highlander01 Highlander01 is offline Formula to return a value of 1,2,3 or based on a set criteria Windows 10 Formula to return a value of 1,2,3 or based on a set criteria Office 2016
Novice
Formula to return a value of 1,2,3 or based on a set criteria 		 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 18
Highlander01 is on a distinguished road
Default
Excellent, thank you.
Reply With Quote
  #3  
Old 06-02-2017, 01:17 PM
Highlander01 Highlander01 is offline Formula to return a value of 1,2,3 or based on a set criteria Windows 10 Formula to return a value of 1,2,3 or based on a set criteria Office 2016
Novice
Formula to return a value of 1,2,3 or based on a set criteria 		 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 18
Highlander01 is on a distinguished road
Default
Quote:
Originally Posted by NBVC View Post
Like this:

=LOOKUP(DATEDIF(L5,TODAY(),"m"),{0,4,6,12},{1,2,3, 4})
I tried this today and hey presto. Thank you very much.

Appreciated!

Gordon
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to return a value of 1,2,3 or based on a set criteria Return Max Text or Number Value based on Criteria kwilson307 Excel 1 04-20-2017 05:07 AM
Formula to return a value of 1,2,3 or based on a set criteria Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. phillipsdp Excel 1 11-09-2016 12:53 AM
Select value from table based on two criteria gebobs Excel 4 07-21-2016 08:26 AM
Formula to return a value of 1,2,3 or based on a set criteria How to return a value in a data table using vertical and horizontal criteria oswald Excel 1 02-08-2015 02:01 AM
Change values in cells based on criteria SaneMan Excel Programming 2 02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:47 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft