"Gary's Student" skrev i en
meddelelse ...
How about =max(C2:I2)-MIN(C2:I2)

This should work because MIN ignores the empty cells


--
Gary's Student

The expression MAX(C2:H2) in the OP's formula indicates, that the
numbers from C2 to H2 are not always in descending order,
else he would have used C2 instead of MAX(C2:H2), I guess.

LeoH