Need formula help
 

I'm using Excel 2002 with SP3 and am having difficulty with the formula in
one cell.

All of the steps of the formula need to reside in cell D14 so the result is
put there.
May go through up to 20 steps to arrive at result, depending upon current
date, which is present in cell C3 as =TODAY().
Cells O4 through O23 have dates 1/21/2006 through 8/21/2007. Contents of
these cells are formatted to be raw five digit number.
Cells P4 through P23 have differing dollar amounts, from $12,727.27 down to
$0.00.

Basic formula:
=IF(AND(C3=O4),(C3<O5),-P4,Go to next step)
=IF(AND(C3=O5),(C3<O6),-P5,Go to next step)
=IF(AND(C3=O6),(C3<O7),-P6,Go to next step)
etc., until
=IF(AND(C3=O22),(C3<O23)-P22,P23)

Its the "Go to next step" that won't work, and there appears to be a short
limit on how long a formula can be, so I can't seem to find a way to
concatonate one step to the next.

Help will be greatly appreciated.

--
Paul Frank

Need formula help
 

Try instead in D14:
=IF(C3="","", -VLOOKUP(C3,$O$4:$P$23,2))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Paul" wrote in message
...
I'm using Excel 2002 with SP3 and am having difficulty with the formula in
one cell.

All of the steps of the formula need to reside in cell D14 so the result
is
put there.
May go through up to 20 steps to arrive at result, depending upon current
date, which is present in cell C3 as =TODAY().
Cells O4 through O23 have dates 1/21/2006 through 8/21/2007. Contents of
these cells are formatted to be raw five digit number.
Cells P4 through P23 have differing dollar amounts, from $12,727.27 down
to
$0.00.

Basic formula:
=IF(AND(C3=O4),(C3<O5),-P4,Go to next step)
=IF(AND(C3=O5),(C3<O6),-P5,Go to next step)
=IF(AND(C3=O6),(C3<O7),-P6,Go to next step)
etc., until
=IF(AND(C3=O22),(C3<O23)-P22,P23)

Its the "Go to next step" that won't work, and there appears to be a short
limit on how long a formula can be, so I can't seem to find a way to
concatonate one step to the next.

Help will be greatly appreciated.

--
Paul Frank