Home |
Search |
Today's Posts |
#1
|
|||
|
|||
two quick questions on excel. please answer as soon as possible...
question 1
can you use the MAX function to check more than one condition? question 2 when entering a formula by selecting cell references, do you only need to type the operators and the initial "="? |
#2
|
|||
|
|||
Here is an example that tests column A for the value a, and gets the MAX
value in B that is less than 10 =MAX(IF(A1:A10="a",IF(B1:B10<10,B1:B10))) it is an array formula, so commit with Ctrl-Shift-Enter, -- HTH RP (remove nothere from the email address if mailing direct) "Microofficetester" wrote in message ... question 1 can you use the MAX function to check more than one condition? question 2 when entering a formula by selecting cell references, do you only need to type the operators and the initial "="? |
#3
|
|||
|
|||
Hi
1. Not really sure what you're trying to achieve. Do you mean an array formula such as =MAX(IF(A1:A100="value1")*(B1:B100="value2"),C1:C1 00)) 2. Yes -- Regards Frank Kabel Frankfurt, Germany "Microofficetester" schrieb im Newsbeitrag ... question 1 can you use the MAX function to check more than one condition? question 2 when entering a formula by selecting cell references, do you only need to type the operators and the initial "="? |
#4
|
|||
|
|||
thanks for answering the second question
question 1 was a test question that was given by one of my teachers. to make the question simple and try to make you guys understand better let me give you the question word for word TRUE OR FALSE YOU CAN USE THE MAX FUNCTION TO CHECK MORE THAN ONE CONDITION "Microofficetester" wrote: question 1 can you use the MAX function to check more than one condition? question 2 when entering a formula by selecting cell references, do you only need to type the operators and the initial "="? |
#5
|
|||
|
|||
I would say the answer to the question is False, but to me it's poorly
worded. -- Regards, Fred Please reply to newsgroup, not e-mail "microofficetester" wrote in message ... thanks for answering the second question question 1 was a test question that was given by one of my teachers. to make the question simple and try to make you guys understand better let me give you the question word for word TRUE OR FALSE YOU CAN USE THE MAX FUNCTION TO CHECK MORE THAN ONE CONDITION "Microofficetester" wrote: question 1 can you use the MAX function to check more than one condition? question 2 when entering a formula by selecting cell references, do you only need to type the operators and the initial "="? |
#6
|
|||
|
|||
=IF(MAX(A1:A10)<10,"true","false")
Technically, this would test the condition of all 10 cells. You could also use MAX() in place of OR() and receive the same result, though I don't know why you would want to. It is a strange, useless, badly worded question, as far as I can see. Tim C "Fred Smith" wrote in message ... I would say the answer to the question is False, but to me it's poorly worded. -- Regards, Fred Please reply to newsgroup, not e-mail "microofficetester" wrote in message ... thanks for answering the second question question 1 was a test question that was given by one of my teachers. to make the question simple and try to make you guys understand better let me give you the question word for word TRUE OR FALSE YOU CAN USE THE MAX FUNCTION TO CHECK MORE THAN ONE CONDITION "Microofficetester" wrote: question 1 can you use the MAX function to check more than one condition? question 2 when entering a formula by selecting cell references, do you only need to type the operators and the initial "="? |
#7
|
|||
|
|||
Hi
question doesn't make sense - MAX returns the maximum value of a range or up to 30 different ranges - there are no conditions in play, unless it is nested with an IF statement. --- (from help) MAX(number1,number2,...) - Number1, number2, ... are 1 to 30 numbers for which you want to find the maximum value. --- if the question was You can use the MAX function to check more than one RANGE - answer = TRUE as it is currently worded i would go for FALSE as checking Conditions is not the purpose of a MAX function. Good luck! Cheers JulieD "microofficetester" wrote in message ... thanks for answering the second question question 1 was a test question that was given by one of my teachers. to make the question simple and try to make you guys understand better let me give you the question word for word TRUE OR FALSE YOU CAN USE THE MAX FUNCTION TO CHECK MORE THAN ONE CONDITION "Microofficetester" wrote: question 1 can you use the MAX function to check more than one condition? question 2 when entering a formula by selecting cell references, do you only need to type the operators and the initial "="? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
SPAM in Excel General Questions | Excel Discussion (Misc queries) |