I think I figured it out:

E9 is =IF(AND(G9=0,G10=0),"",MIN(G9:G10)+E10)
and
G9 is =IF(D9="","",D10-D9)

Thanks for everyone's input.

"Bearacade" wrote:


You really need to check your formulas...

You are getting a 0 because that is how your formula is calling it.

Your orginal formula is IF(G9=G10,G9,G10), which basically look for
the larger of two number in G9 and G10. That's why I replaced it with
Large(G9:G10,1)

G9 is -10 and G10 is 10, so the larger number is 10

If you use your original formula, IF(-10=10 (which is false), -10,
10)

So you would still get 10 as your answer...



TammyS Wrote:
Sorry but it didn't seem the problem was with col. D. Substitute 9 and
10
for the numbers in the example I gave (it's the same formula down the
page
just using different scenarios to make sure the formula is correct).

=IF(D9="","",IF(AND(G90,G100),"",LARGE(G9:G10,1) +E10))

G9 is -10
G10 is 10
E10 is 0
E9 (the result) is 0 (should be -10)




--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=563067