Liz,

Depends on which difference you want. Try

=E1-F1+MAX(A1:D1)

or

=F1-E1+MAX(A1:D1)

or even

=ABS(E1-F1)+MAX(A1:D1)

HTH,
Bernie
MS Excel MVP

"Liz C" wrote in message
...
Hi.

I have a range of cells from A1 thru D1 with a total of A1:D1 in E1 and a
total to compare that to in F1.

I want to take the difference between E1 and F1 and add it to the cell
between A1 and D1 that has the largest value.

Any ideas how I might accomplish this?

Thanks!