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




"Workbook" wrote:

In Cell B30, I would like to create an IF Statement that will give me the
greatest number from the Cell Range B2:B29.