Prev: Please help.,
Next: compare and merge documents in 2007
From: deholmes on 27 May 2010 15:53
I am trying to create a equipment rental invoice using one spreedsheet as the
data base, I am stump on hoe to make the cell that will contain the charge of
the rental
If I use dates and in an cell I create a formula that figures out the number
os days the equipment is out
in the total charge sell I want the amount to go
so for excample I have day out, day in, day, week ,month,
total charge
05/17/10 05/18/10 32.00 128.0
384.00 ?????
How can I make the amopunt from the dates entered go into the cell??(total
charge)
Is there a rental template out there or is there a simple formula??

From: Fred Smith on 27 May 2010 18:31
Providing the actual cell address or columns makes it much easier for people
to provide formulas useful to you. In additional, you'll need to define what
determines a week's rental (any period over 7 days?) versus a month's rental
(over 30 days?). Assuming your columns are A to F, see if the following gets
you started:

=if(b1-a1<7,(b1-a1+1)*c1,if(b1-a1<30,(b1-a1+1)/7*d1,(b1-a1+1)/30*e1))

Regards,
Fred

"deholmes" <deholmes(a)discussions.microsoft.com> wrote in message
news:B55DFB28-22E3-4078-88F1-7C9DD90E9814(a)microsoft.com...
>I am trying to create a equipment rental invoice using one spreedsheet as
>the
> data base, I am stump on hoe to make the cell that will contain the charge
> of
> the rental
> If I use dates and in an cell I create a formula that figures out the
> number
> os days the equipment is out
> in the total charge sell I want the amount to go
> so for excample I have day out, day in, day, week
> ,month,
> total charge
> 05/17/10 05/18/10 32.00
> 128.0
> 384.00 ?????
> How can I make the amopunt from the dates entered go into the cell??(total
> charge)
> Is there a rental template out there or is there a simple formula??
>

 | 
Pages: 1
Prev: Please help.,
Next: compare and merge documents in 2007