Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Paul
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 09:02 PM
2 Nesting questions Starchaser Excel Worksheet Functions 7 January 20th 06 07:53 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"