Don't know how that formula returns 0. With those values, that formula is
essentially G10+E10 = 10 + 0 = 10

-Simon

"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(G9>0,G10>0),"",LARGE(G9:G10,1)+E10))
>
> G9 is -10
> G10 is 10
> E10 is 0
> E9 (the result) is 0 (should be -10)
>
>
> "SimonCC" wrote:
>
> > Not really sure what happened to cells in column D in your original formula.
> > Let me just attempt this based on the examples you gave:
> > =MIN(G7:G8)+E8
> > And the formula will remain this simple until you can provide a different
> > example which would make the formula wrong.
> >
> > -Simon
> >
> > "TammyS" wrote:
> >
> > > Hi,
> > >
> > > I appreciate everyone's help with this. But it's still returning only
> > > positive numbers.
> > >
> > > G7 is 10
> > > G8 is -20
> > > E8 is 0
> > > E7 (the result) is 10 (should be -20)
> > >
> > > G11 is blank
> > > G12 is -10
> > > E12 is -50
> > > E11 (the result) is blank (should be -60)
> > >
> > > G13 is -10
> > > G14 is -10
> > > E14 is -40
> > > E13 (the result) is 0 (should be -50)
> > >
> > > "Bearacade" wrote:
> > >
> > > >
> > > > You are getting a #value because of the E10 comment. Change it to
> > > > IF(E10=0,0,E10))
> > > >
> > > > Another thing is you might want to use large instead of the the IF
> > > > command, I think it's cleaner:
> > > >
> > > > Personally, you don't even need the whole E10 thing..
> > > >
> > > > =IF(D9="","",IF(AND(G9>0,G10>0),"",LARGE(G9:G10,1)+E10))
> > > >
> > > > It's cleaner this way.. you will STILL get a #Value if anything other
> > > > than number is in E10..
> > > >
> > > > You can protect against that with:
> > > >
> > > > =IF(D9="","",IF(AND(G9>0,G10>0),"",LARGE(G9:G10,1)+IF(ISNUMBER(E10),E10,0)))
> > > >
> > > >
> > > > --
> > > > Bearacade
> > > >
> > > >
> > > > ------------------------------------------------------------------------
> > > > Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> > > > View this thread: http://www.excelforum.com/showthread...hreadid=563067
> > > >
> > > >