Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The IF function
How can i use the IF funvction to find the highest value, from a list of 19
values? |
#2
|
|||
|
|||
Don't use if for that. Use =max(A1:A19) or something like that. Szalapski -- TommySzalapski ------------------------------------------------------------------------ TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561 View this thread: http://www.excelforum.com/showthread...hreadid=398796 |
#3
|
|||
|
|||
Emma,
You don't need an IF function. Instead, use the MAX function. E.g., =MAX(A1:A19) will return the largest value in cells A1:A19. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Emma" wrote in message ... How can i use the IF funvction to find the highest value, from a list of 19 values? |
#4
|
|||
|
|||
Why IF?
Assuming values in range A1:A19 =max(A1:A19) HTH "Emma" wrote: How can i use the IF funvction to find the highest value, from a list of 19 values? |
#5
|
|||
|
|||
I'm currently doing a course and it is in one of the exercises, and it states that i have to use IF "Ray A" wrote: Why IF? Assuming values in range A1:A19 =max(A1:A19) HTH "Emma" wrote: How can i use the IF funvction to find the highest value, from a list of 19 values? |
#6
|
|||
|
|||
Chip,
Is it not possible to use the IF function, it's just that I am currently studying for a microsoft office certification and one of the exercises is to use the IF function in order to do it? "Chip Pearson" wrote: Emma, You don't need an IF function. Instead, use the MAX function. E.g., =MAX(A1:A19) will return the largest value in cells A1:A19. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Emma" wrote in message ... How can i use the IF funvction to find the highest value, from a list of 19 values? |
#7
|
|||
|
|||
Hi Emma
The other guys have given you the simplest and neatest answer. However, knowing some tutors, they throw in a question to see if you can think around it. Try this =IF(A1:A19="","",MAX(A1:A19)) HTH Michael Mitchelson "Emma" wrote: I'm currently doing a course and it is in one of the exercises, and it states that i have to use IF "Ray A" wrote: Why IF? Assuming values in range A1:A19 =max(A1:A19) HTH "Emma" wrote: How can i use the IF funvction to find the highest value, from a list of 19 values? |
#8
|
|||
|
|||
Emma,
How about =IF(MAX(A1:A10)MAX(A11:A19),MAX(A1:A10),MAX(A11:A 19)) It uses an IF function, but I don't think it's the answer the questioner is looking for :-) Henry "Emma" wrote in message ... I'm currently doing a course and it is in one of the exercises, and it states that i have to use IF "Ray A" wrote: Why IF? Assuming values in range A1:A19 =max(A1:A19) HTH "Emma" wrote: How can i use the IF funvction to find the highest value, from a list of 19 values? |
#9
|
|||
|
|||
=IF(A1:A19="","",MAX(A1:A19))
Returns #VALUE! for me becuse the array A1:A19 cannot resolve to TRUE/FALSE =IF(COUNT(A1:A19)=0,"",MAX(A1:A19)) would do what you are suggesting HTH Sandy Replace@mailinator with @tiscali.co.uk "Michael" wrote in message ... Hi Emma The other guys have given you the simplest and neatest answer. However, knowing some tutors, they throw in a question to see if you can think around it. Try this =IF(A1:A19="","",MAX(A1:A19)) HTH Michael Mitchelson "Emma" wrote: I'm currently doing a course and it is in one of the exercises, and it states that i have to use IF "Ray A" wrote: Why IF? Assuming values in range A1:A19 =max(A1:A19) HTH "Emma" wrote: How can i use the IF funvction to find the highest value, from a list of 19 values? |
#10
|
|||
|
|||
Um, shouldn't you just ask whomever is in charge of your certification? It sounds like you are trying to get test answers. Szalapski -- TommySzalapski ------------------------------------------------------------------------ TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561 View this thread: http://www.excelforum.com/showthread...hreadid=398796 |
#11
|
|||
|
|||
Emma,
I understand that if the assignment asks you to use IF(), you "must" use IF(), even though MAX() seems to be the better choice. You might want to ask your instructor (if you have one) what they are looking for and why. Michael wrote: However, knowing some tutors, they throw in a question to see if you can think around it. Try this =IF(A1:A19="","",MAX(A1:A19)) Dovetailing what Michael said, perhaps the following is something like what the assignment is looking for: =IF(NOT(ISNUMBER(A1:A19)),"",MAX(A1:A19)) The point is: create a formula that will display the max without ever incurring an error. It's called "bullet-proofing", and it is certainly a useful ability for a professional to learn. |
#12
|
|||
|
|||
Thank you all for your help. I'm glad i found this site now.
Will give your solutions a try in the morning. Thanks Again. :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |