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?