1 week, two weeks and more

[Morten7422]

Hi Guys.

starting anew company and want to work the rental of my stock out on a calendar sliding scale.

So if someone take my stock for a week it gets charged at X
if they take it for a month it becomes X less 25% or something similar..

so i would have a date formula from for start and finish which would give me the #of days

how do i then take that value and tell it to charge X for one week and X minus 20% for a month?

cheers Morten

 

[timfritsch]

Sounds like a prime candidate for vlookup.

MS Excel: VLOOKUP Function (WS)


Tim