View Single Post
 
Old 06-01-2017, 12:00 PM
Highlander01 Highlander01 is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2016
Location: Portsmouth, England
Posts: 18
Highlander01 is on a distinguished road
Default Formula to return a value of 1,2,3 or based on a set criteria

Dear Experts

Help!

I need to introduce a set of criteria in my spread sheet (Office 2010) based on a date.

I have a date in cell L5 and want to return a value of 1,2,3 or 4 in M5 based on the following criteria:
<4 months to return a value of 1
=>4 – <6 months to return a value of 2
=>6 – <12 months to return a value of 3
=>12 months to return a value of 4

Any help would be greatly appreciated

Gordon
Reply With Quote