PC Review


Reply
Thread Tools Rate Thread

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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting fileterd cells with spesific value Sjur Microsoft Excel Worksheet Functions 4 1st Oct 2008 03:11 PM
return sporadic numbers in a cell-area from a spesific number farmer Microsoft Excel Worksheet Functions 4 26th Mar 2008 01:48 PM
go and check on spesific page and then run macro pswanie Microsoft Excel Programming 1 30th Dec 2007 10:46 AM
Query that returns only one record for each unique value in a spesific field Hallgeir Microsoft Access Queries 2 23rd May 2006 12:18 AM
check if reference exists, then return its value or return 0 doudou Microsoft Excel Worksheet Functions 1 4th Jun 2005 09:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:13 AM.