+ Reply to Thread
Results 1 to 5 of 5

Round to the nearest set range

Hybrid View

sput_sput Round to the nearest set range 08-20-2010, 12:53 PM
DonkeyOte Re: Round to the nearest set... 08-20-2010, 12:56 PM
sput_sput Re: Round to the nearest set... 08-20-2010, 01:09 PM
DonkeyOte Re: Round to the nearest set... 08-20-2010, 01:10 PM
sput_sput Re: Round to the nearest set... 08-20-2010, 01:10 PM
  1. #1
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Round to the nearest set range

    You can use:

    Q3: =DATEDIF(O3,TODAY(),"m")
    copied down

    R3: =IF($Q3<MIN($F$4:$K$4),0,LOOKUP($Q3,$F$4:$K$4,INDEX($F$5:$K$7,MATCH($P3,$E$5:$E$7,0),0)))
    copied down

    edit: modified per post #3
    Last edited by DonkeyOte; 08-20-2010 at 01:10 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1