Hi TwoDot,

i've seen solutions to your question and depending on the non-blank cell
values...
i'll mix Gary's and Valko's formula...

perhaps something like this..

=IF(COUNT(A1:A5)<3,"INC!",ROUNDUP((SMALL(A1:A5,1)+ SMALL(A1:A5,2)+SMALL(A1:A5,3))/3,0))

short test with 3 cells containing -2.5 each....2 blank cells...
result is -3

if you want to round down the average, you can take a look at INT() function
on help files....

regards,
driller
--
*****
birds of the same feather flock together..



"TwoDot" wrote:

I have 5 cells in a row. I want to average the 3 lowest numbers in those
five cells and round up to the next integer.