Formula query

[Steve]

Hi
I've devised a basic spreadsheet which calculates the cost to hire a unit.

Col A = Item No
Col B = Date from
Col C = Date to
Col D = No of days
Col E = Cost per day
Col F = Net cost
Col G = VAT
Col H = Gross

This works fine, but what I want to include is the minimum rental period is
three months. So If someone rents the item for less than three months, the
figure in the net cost column would show the minimum cost

TIA
Steve

 

[JulieD]

Hi Steve

if cell F2 formula would be
=MAX(d2,90)*E2

Cheers
JulieD

 

[Steve]

Thanks Julie - that works fine

Steve

Hi Steve

if cell F2 formula would be
=MAX(d2,90)*E2

Cheers
JulieD

 

[JulieD]

you're welcome & thanks for the feedback

Thanks Julie - that works fine

Steve

 

[Steve]

Hi
Is it possible to put this info into a template so that it can be opened as
an empty page but the calcalations automatically start working when the data
is put in. If possible do anyone know of a site that gives a tutorial on
templates?

TIA
Steve

 

[JulieD]

Hi Steve

a template is just a copy of your workbook with all the formulas & general
text in it. Every time you open a workbook based on the template you get
this text & formulas and you put in the things that are specific to the
event you want to record in the workbook.

so, set your workbook up, put all the formulas in (blank lines ready for new
input can still have formulas copied into them - they just won't calculate
until the numbers are plugged in). Once you're happy with it choose file /
save as and under type - use template - give it a name and choose save. now
close it.

now when you want a "blank" copy of the workbook, choose File / New - if you
have ver 97 or 2000 you should see your template there for you to select.
If you have 2002 or 2003 you have to choose under the heading of "from
template" (or similar) - on my computer (or general templates) ... then you
should be able to find the template you created. now, just fill in the
specific details, the formulas should calculate correctly and then you can
save this new workbook where you want.

hope this makes sense.

Cheers
JulieD

 

[Debra Dalgleish]

There are instructions on the Microsoft site:

http://office.microsoft.com/en-ca/assistance/HP051995961033.aspx

And there are template examples here:

http://office.microsoft.com/en-ca/templates/default.aspx

 

[Steve]

Hi Julie
Once again thanks very much, everything went just as you said.

best regards
Steve

 

[JulieD]

Hi Steve

glad to assist.

Cheers
JulieD

Hi Julie
Once again thanks very much, everything went just as you said.

best regards
Steve