=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?