Need help with a Custom Multiplication Function

[camgraf]

Hi All,

I was hoping someone would be able to help me with a small problem,

I need a function that calculates a price based on duration,

I would like to be able to choose a value from a drop down box (this being the length of time in sec) that would have an assigned rate attached to it that would be applied to the dollar amount in the following column giving the final rate in the following column,

Example

15 sec selected in dropbox will result in the below equation

00:15 = (.06 x base rate) = Actual Cost

Below are the Duration that will be used and the rates I need attached to them

Time (selection)|Rate|Base rate|Actual Cost
5 | 0.3 | $xxx | $xxx
10 | 0.5 | $xxx | $xxx
15 | 0.60 | $xxx | $xxx
30 | 1.00 | $xxx | $xxx
45 | 1.60 | $xxx | $xxx
60 | 2.00 | $xxx | $xxx

Image attached shows the above a bit clearer (2nd image)


Its a bit confusing but any help would be greatly appreciated

Thanks

[avk]

using Vlookup or index match you can do. If you attach sample file its more helpful of both & quick result.

[David A Coop]

Welcome to the forum camgraf,

It's difficult to understand what you're asking because you posted three examples, but is all of them you has $xxx in the result fields. I can't tell if the "base rate" you speak of varies, or is constant.

That said, assuming you have the Data Validation dropdown in A1 on the same sheet you posted, the formula =VLOOKUP(A1,$A$4:$B$9,2,0) will display the rate.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[Glenn Kennedy]

If the times are entirely variable, you'll need a slightly different approach, but still using VLOOKUP

=VLOOKUP(D2,$A$2:$B$7,2,TRUE)

[camgraf]

Got it sorted now,

Cant thank you all enough