need help to achieve this calculation


G

Guest

Col A --------Col B ---------Col C
02/19/07 --- 75
02/20/07 --- 76
02/21/07 --- 37
02/22/07 --- 36.5
02/23/07 --- 17.50

Col. D --- Col E
02/21/07 --2
02/23/07 -- 1.5
I am looking for a formula that gives me the following output results.
If Col D first date exists in Col A ,match the date and multiply the
corresponding
value in Col B with Col E value from first date to next date in Col D.If
second date in
Col D exists in Col A multiply the corresponding value in Col B with Col E
values
of both first date and next date.If Col D date does not exists,extract the
Col B value
without any change.
the ultimate results in Col C are 75,76,37multiplied by 2=74,36.5 multiplied
by 2
=73,52.5.
Thanks in advance for any help.
 
Ad

Advertisements

G

Guest

I started the data entries in row 1. I added in column F next to the 2 and
the 1.5
a test theat returned 1 if the date was found in column A and 0 if the date
was not found

=IF(MATCH(D1,A$1:A$5,0)>0,1,0)

then the formular in column C becomes simple

=B1*((E$1*F$1)+(E$2*F$2))

Make sure the $ are include correctly

I'm not sure from you instructions what happens if both dates are found. I
think you wantted the numbers multilplied by 2 + 1.5 = 3.5.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top