W
Workbook
In Cell B30, I would like to create an IF Statement that will give me the
greatest number from the Cell Range B2:B29.
greatest number from the Cell Range B2:B29.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=MAX(B2:B29)
no ifs are needed.
no ifs are needed.
F
Fred Smith
Try:
=max(b2:b29)
Regards,
Fred.
=max(b2:b29)
Regards,
Fred.
X
xlmate
try
=MAX(B2:B29)
this will retrun the highest value in the range
HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.
Thank You
cheers, francis
=MAX(B2:B29)
this will retrun the highest value in the range
HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.
Thank You
cheers, francis
S
Shane Devenshire
Hi,
Can I possibly add anything to the previous posts? Not really, that is your
best solution, but
=LARGE(B2:B29,1)
Has the advantage, for other problems of allowing you to fine the 2nd,
3rd,... largest numbers. And of course the above formula give you exactly
the same result as MAX. Likewise there is a MIN function and a SMALL
function for your consideration.
Can I possibly add anything to the previous posts? Not really, that is your
best solution, but
=LARGE(B2:B29,1)
Has the advantage, for other problems of allowing you to fine the 2nd,
3rd,... largest numbers. And of course the above formula give you exactly
the same result as MAX. Likewise there is a MIN function and a SMALL
function for your consideration.
W
Workbook
Thank you. It works great. Could I modify this formula so that if it was in
Sheet 2 it would take data from Sheet 1?
Sheet 2 it would take data from Sheet 1?
W
Workbook
I appreciate your input. Thank you very much. Could I modify this formula
so that if it was in Sheet 2 it would take data from Sheet 1?
so that if it was in Sheet 2 it would take data from Sheet 1?
W
Workbook
I value you're input. Thank you. Could I modify this formula so that if it
was in Sheet 2 it would take data from Sheet 1?
was in Sheet 2 it would take data from Sheet 1?
W
Workbook
O cool. Thank you for teaching me extra stuff. I made sure to take notes.
Thank you! Could I modify this formula so that if it was in Sheet 2 it would
take data from Sheet 1?
Thank you! Could I modify this formula so that if it was in Sheet 2 it would
take data from Sheet 1?
R
Rick Rothstein
Assume there was a space in the sheet name as you show...
=MAX('Sheet 1'!B2:B29)
If there aren't any spaces in the name of the sheet, then you don't need the
apostrophes....
=MAX(Sheet1!B2:B29)
=MAX('Sheet 1'!B2:B29)
If there aren't any spaces in the name of the sheet, then you don't need the
apostrophes....
=MAX(Sheet1!B2:B29)
W
Workbook
: ) Thanks Rick, I kept putting the sheet reference before MAX in different
variations and I couldn't figure out why it wasn't working. I feel really
foolish now but I am so grateful for you're input. Thanks man. I appreciate
you're help.
variations and I couldn't figure out why it wasn't working. I feel really
foolish now but I am so grateful for you're input. Thanks man. I appreciate
you're help.
F
Fred Smith
The easiest way to get formulas correct is to let Excel do them. Try it this
way in the future:
1. Type in: =Max(
2. Navigate to the range you want to find the max of. That is, click on
Sheet1's tab, and highlight cells b2:b9.
3. You will see that Excel has created the proper range for you.
4. Now type the closing parentheses and hit enter. Voila, your formula is
created, and you never have to type a range address again.
Regards,
Fred.
way in the future:
1. Type in: =Max(
2. Navigate to the range you want to find the max of. That is, click on
Sheet1's tab, and highlight cells b2:b9.
3. You will see that Excel has created the proper range for you.
4. Now type the closing parentheses and hit enter. Voila, your formula is
created, and you never have to type a range address again.
Regards,
Fred.