Hi

I need to calculate the night rate within excel which I have done without a
problem as it is done using a lookup table. =VLOOKUP(C17,RATETABLE,2).

I now need to ammend this to include a second lookup relating to a separate
cell which I can get working on its own, as it is a further lookup
=VLOOKUP(F23,discount_range,2) (this effectively discounts a % if the
customer places multiple bookings.

I then also need to add an if function which will say if the entry into a
cell is yes then deduct a discount, if the input is no then dont discount,
which I have got to this
=IF(F19="Yes",F28*Repeat_Customer_Discount,F28*0)

I know the first two calculations work on their own I am around 70% sure
that the third works on its own, but I need to put them all together. I have
been trying to do this without success for well over a week now an I would
appreciate any help that you can provide.

Many thanks

Louise

I need to put them all together.

In what way? How are they related?

Biff

"Confused" wrote in message
...
Hi

I need to calculate the night rate within excel which I have done without
a
problem as it is done using a lookup table. =VLOOKUP(C17,RATETABLE,2).

I now need to ammend this to include a second lookup relating to a
separate
cell which I can get working on its own, as it is a further lookup
=VLOOKUP(F23,discount_range,2) (this effectively discounts a % if the
customer places multiple bookings.

I then also need to add an if function which will say if the entry into a
cell is yes then deduct a discount, if the input is no then dont discount,
which I have got to this
=IF(F19="Yes",F28*Repeat_Customer_Discount,F28*0)

I know the first two calculations work on their own I am around 70% sure
that the third works on its own, but I need to put them all together. I
have
been trying to do this without success for well over a week now an I would
appreciate any help that you can provide.

Many thanks

Louise

Hi Biff sorry should of included that first post on here. I need one
calculation that calulates a night rate for a customer, which is
=VLOOKUP(C17,RATETABLE,2) this then gives the appropriate night rate. if they
are a repeat customer then it needs to deduct a discount, at the moment I
have a cell set up with validation on for either a yes entry or a no entry,
so I assumed I would add an IF function as in if cell f19=YES then -
discount, and so on, if the customer is also booking in multiple bookings
then a lookup table is used for a further discount which I can get running as
=VLOOKUP(F23,discount_range,2)

I need it to calculate the night rate and then discount if necessary based
on the repeat customer cell, and deduct a further discount if necessary from
the lookup table for multiple bookings.

I hope that makes sense.

Many thanks

Louise

"T. Valko" wrote:

I need to put them all together.

In what way? How are they related?

Biff

"Confused" wrote in message
...
Hi

I need to calculate the night rate within excel which I have done without
a
problem as it is done using a lookup table. =VLOOKUP(C17,RATETABLE,2).

I now need to ammend this to include a second lookup relating to a
separate
cell which I can get working on its own, as it is a further lookup
=VLOOKUP(F23,discount_range,2) (this effectively discounts a % if the
customer places multiple bookings.

I then also need to add an if function which will say if the entry into a
cell is yes then deduct a discount, if the input is no then dont discount,
which I have got to this
=IF(F19="Yes",F28*Repeat_Customer_Discount,F28*0)

I know the first two calculations work on their own I am around 70% sure
that the third works on its own, but I need to put them all together. I
have
been trying to do this without success for well over a week now an I would
appreciate any help that you can provide.

Many thanks

Louise

Hi

You know how to calculate each figure
Rate
Repeat Discount
Multiple Discount

Your final figure needs to be
Rate*(1-Repeat Discount)*(1-Multiple Discount)
If the discount is zero, then it will be multiplying the value by 1,
hence leaving it as it is

--
Regards

Roger Govier


"Confused" wrote in message
...
Hi Biff sorry should of included that first post on here. I need one
calculation that calulates a night rate for a customer, which is
=VLOOKUP(C17,RATETABLE,2) this then gives the appropriate night rate.
if they
are a repeat customer then it needs to deduct a discount, at the
moment I
have a cell set up with validation on for either a yes entry or a no
entry,
so I assumed I would add an IF function as in if cell f19=YES then -
discount, and so on, if the customer is also booking in multiple
bookings
then a lookup table is used for a further discount which I can get
running as
=VLOOKUP(F23,discount_range,2)

I need it to calculate the night rate and then discount if necessary
based
on the repeat customer cell, and deduct a further discount if
necessary from
the lookup table for multiple bookings.

I hope that makes sense.

Many thanks

Louise

"T. Valko" wrote:

I need to put them all together.

In what way? How are they related?

Biff

"Confused" wrote in message
...
Hi

I need to calculate the night rate within excel which I have done
without
a
problem as it is done using a lookup table.
=VLOOKUP(C17,RATETABLE,2).

I now need to ammend this to include a second lookup relating to a
separate
cell which I can get working on its own, as it is a further lookup
=VLOOKUP(F23,discount_range,2) (this effectively discounts a % if
the
customer places multiple bookings.

I then also need to add an if function which will say if the entry
into a
cell is yes then deduct a discount, if the input is no then dont
discount,
which I have got to this
=IF(F19="Yes",F28*Repeat_Customer_Discount,F28*0)

I know the first two calculations work on their own I am around 70%
sure
that the third works on its own, but I need to put them all
together. I
have
been trying to do this without success for well over a week now an
I would
appreciate any help that you can provide.

Many thanks

Louise