Re: Value between 2 dates
- From: "Fred Smith" <fredsmith99@xxxxxxxxx>
- Date: Fri, 19 Aug 2005 22:18:06 -0600
You need to create a clearer description of your problem in order to get the
solution you are looking for. Try to simplify your problem, preferably focusing
on one row. Normally when you get the solution for one row, you can copy down
for the rest.
Another useful technique is to ask for one solution at a time. For example,
create another post solely for your date lookup problem. This will help you
specify the problem more clearly. For example, if "A & C may not always match
the dates in the lookup ranges", then tell us what the rules are so they will
always match.
It looks to me like you are trying to calculate the shares resulting from a
dividend reinvestment program. Is this correct? If so, why does F3 (presumably
for a dividend declared between 2/6/99 {is 2/16/99 a typo?} and 2/12/99) extract
a price of 15.94 when that occurred on 3/12/99? Is 3/12/99 the dividend
reinvestment date? If so, then I think you will need to add this date to your
row. This will then allow you to look it up.
Hope this helps.
--
Regards,
Fred
"AG" <AG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:376F1525-B0A7-4415-A4BC-1D10E5A10F86@xxxxxxxxxxxxxxxx
>I need formulas to calculate a dividend when it occurs between 2 dates.
> I've tried a few options & looked through the group but I don't have the
> skill to put the info I found to use.
> Thanks for any help.
>
> I have a sheet named "Value" as setup below.
> I have ranges for dividend rates and daily prices as below.
> What I need are the formulas to extract the Div Rate for column E and the
> Div Price for column F.
> So that I extract .25 for cell F3 and 15.94 for cell G3 and 0.484 for cell
> F8 and G8 when they occur.
> The lookup values in columns A & C may not always match the dates in the
> lookup ranges and finding the closest match that results using a standard
> lookup function won't always be correct.
>
>
> Value Sheet
> Monday Friday Current Div
> Added Total
> Date Price Date Price Shares Rate Price Shares
> Shares
> 2/8/99 16.3 2/5/99 16.28 1000 1000
> 2/16/99 15.94 2/12/99 15.86 =I2 .25 15.94 15.684
> 1015.684
> 2/22/99 16.07 2/19/99 15.8 =I3
> 3/1/99 15.82 2/26/99 15.85 =I4
> 3/8/99 16.23 3/5/99 16.24 =I5
> 3/15/99 16.4 3/12/99 16.43 =I6
> 3/22/99 15.96 3/19/99 16.45 =I7 0.484 16.44 29.957
> 1045.641
> 3/29/99 15.86 3/26/99 15.69 =I8
>
> DivTable set as a named range
> Date Rate
> 3/4/99 2.038
> 3/12/99 0.25
> 3/17/99 0.484
> 3/30/99 0.063
>
> PriceTable set as a named range
> Date Price
> 3/3/99 15.84
> 3/4/99 16.02
> 3/5/99 16.24
> 3/8/99 16.23
> 3/9/99 16.16
> 3/10/99 16.34
> 3/11/99 16.36
> 3/12/99 15.94
> 3/15/99 16.4
> 3/16/99 16.41
> 3/17/99 16.44
> 3/18/99 16.58
> 3/19/99 16.45
> 3/22/99 15.96
> 3/23/99 15.63
> 3/24/99 15.75
> 3/25/99 15.82
> 3/26/99 15.69
> 3/29/99 15.86
> 3/30/99 15.63
>
>
>
.
- Follow-Ups:
- Re: Value between 2 dates
- From: AG
- Re: Value between 2 dates
- References:
- Value between 2 dates
- From: AG
- Value between 2 dates
- Prev by Date: RE: accessing an address stored in another cell
- Next by Date: Re: accessing an address stored in another cell
- Previous by thread: Value between 2 dates
- Next by thread: Re: Value between 2 dates
- Index(es):
Relevant Pages
|
