Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default What function to use

I have a question, I have an assigment to do but I do not know how. Here is
the thing there is going to be 3+ columns. In Each column it will have some
numbers, than from those numbers I need to make a formula that will put that
article in right category. Here is Example (I don't know how to explain
because they did not know how to explain to me but this is what I think it is)
Coulmn A Column B Column C
500 0 0
400 0 0
100 0 0

As you can see column A first would be in category 1 as the best, 400 in
category 2 and 100 in 3. Now if in 400 there was number 3 in column B it
should be placed in category 3. Also 500 if it had lets say 5 in column C it
should go to category 2, had 10 in column C it should go to category 3. So it
goes like in chain, if 500 had 3 in Column B it should go to category 3.
Now I know I really did confuse you but I am really sorry because I am
really confused.

I would like some kind of formula that would eighter say "Category 1", or
just simple 1

This is for some kind of observation that they came up with and I am really
confused and it is really out of my expertise.

Thank you so much for your time!

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 524
Default What function to use

Sun, 28 Feb 2010 20:25:01 -0800 from cccc
:

I have a question, I have an assigment to do but I do not know how. Here is
the thing there is going to be 3+ columns. In Each column it will have some
numbers, than from those numbers I need to make a formula that will put that
article in right category. Here is Example (I don't know how to explain
because they did not know how to explain to me


If you don't understand an assignment, ask your professor to clarify
it. Working only from your interpretation, we have less chance than
you of guessing what your professor wants.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Data Validation/Lookup function does function correcty Kirkey Excel Worksheet Functions 2 May 25th 09 09:22 PM
copy of excel file not showing formulal/function in the function b oaallam Excel Discussion (Misc queries) 4 September 6th 07 01:20 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
Offset function with nested match function not finding host ss. MKunert Excel Worksheet Functions 1 March 21st 06 10:46 PM
Emulate Index/Match combo function w/ VBA custom function Spencer Hutton Excel Worksheet Functions 2 May 2nd 05 05:26 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"