I need to create a formula that looks at cell P6 and if < 0 does a
calculation, if P6 is equal to 0 it moves to cell Q6 and looks to see if it
is 0 or not, if not then it creates a calculation then onto cell R6 etc.
The calculation needs to be based on whatever the last cell is that is <0.
P6 is the last cell <0 then use that otherwise move to the next cell.
The formula needs to be applicable up to cell W6.
Thanks in advance!

Ok, so if a cell <0 does that mean it contains some number other than 0? If
so, are these numbers always positive?

--
Biff
Microsoft Excel MVP


"liz25mc" wrote in message
...
I need to create a formula that looks at cell P6 and if < 0 does a
calculation, if P6 is equal to 0 it moves to cell Q6 and looks to see if
it
is 0 or not, if not then it creates a calculation then onto cell R6 etc.
The calculation needs to be based on whatever the last cell is that is
<0.
P6 is the last cell <0 then use that otherwise move to the next cell.
The formula needs to be applicable up to cell W6.
Thanks in advance!

Hi,

This returns the number for you to do the calculation on

=INDEX(P6:W6,MATCH(TRUE,INDEX((P6:W6<0),0),0))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"liz25mc" wrote:

I need to create a formula that looks at cell P6 and if < 0 does a
calculation, if P6 is equal to 0 it moves to cell Q6 and looks to see if it
is 0 or not, if not then it creates a calculation then onto cell R6 etc.
The calculation needs to be based on whatever the last cell is that is <0.
P6 is the last cell <0 then use that otherwise move to the next cell.
The formula needs to be applicable up to cell W6.
Thanks in advance!