Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |