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?