Excel 2007 : Sum of greatest number

[cecilj]

I am looking for a fix to a function, here is an example of what i am looking for

--------------Column B------------| Column C--------| Column D
Row 3-----pre-wt------------------| 5.5------------------| Blank
Row 4-----Post wt----------------| 6.6------------------| =IF(C4>1,SUM(C4-C3)," ") Answer is 1.1
Row 5-----Add wt-----------------| 6.9------------------| =IF(C5>1,SUM(C5-C3),D4) Answer is 1.4
Row 6-----Post Treated wt----| 9.1------------------| ??????? answer is 2.2

There will be times when no data will be entered in Row 5 Column C so i need a formula in this column that will take the weight from Row 6 Column C subtract from Row 4 or Row 5 which ever number is larger.

[zbor]

Write this in D2 and pull down:

=IF(C4>1,C4-$C$3,MAX($D$3:D3))

[contaminated]

hi. Maybe this

=C6-MAX(C4:C5)

[contaminated]

ooppps. Hi Zbor. Didn'e see your reply

[cecilj]

okay well i tried it with these numbers for interest sake, it doesn't seem to work what am i missing?

A3=55.789 Blank
A4=55.989 answer is .200
C5=56.120 answer is .331
C6=56.125 answer shows .200 should be .336

is there also a way to have it not show any calculation unless there is a number entered in C6?

[cecilj]

k i changed the formula a bit to get the desired result i needed.
=IF(C6>1,C6-$C$3,MAX($D$3:D3))

now is there a way to have D6 show nothing unless there is data in C6, right now if C6 is blank i get some zeros in D6, not that big of a deal just cosmetically it looks brutes lol

Thanks