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!