# Re: Check value range, then return spesific number?

Claus Busch
Guest
Posts: n/a

 29th Jan 2012
Hi Arne,

Am Sun, 29 Jan 2012 11:54:43 GMT schrieb Arne Pedersen:

> When I enter a number into a cell, another number shows in another cell, based upon the number first entered. A bit more spesific:
> The idea is to calculate the number of instructors needed for a week end seminar. 1 participant requires 1 instructor. Same for 2 participants, and 3.
> 4, 5 and 6 participants requires 2 instructors. 7, 8 and 9 participants requires 3 instructors. And so on. For every 3 participant, we apply 1 instructor.
> So, i.e. if I enter the number 5, i want the number 2 in the cell below.

Number of participants in A1, then in A2:
=VLOOKUP(A1,{0,1;4,2;7,3;10,4;13,5;16,6},2,1)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Sjur Microsoft Excel Worksheet Functions 4 1st Oct 2008 03:11 PM farmer Microsoft Excel Worksheet Functions 4 26th Mar 2008 01:48 PM pswanie Microsoft Excel Programming 1 30th Dec 2007 10:46 AM Hallgeir Microsoft Access Queries 2 23rd May 2006 12:18 AM doudou Microsoft Excel Worksheet Functions 1 4th Jun 2005 09:17 PM

Features