any excel genious out there?

J

James

Active member
Joined
May 13, 2008
Messages
2,098
Reaction score
0
Points
36
=VLOOKUP(Nights,PricePerNight,3)-VLOOKUP(Nights,PricePerNight,3)*IF(F10="yes",Constants!B15,0)-VLOOKUP(Nights,PricePerNight,3)*VLOOKUP(NumberOfCats,CatDiscount,2)

this is my formula and it works however not with the result i was wanting.

=VLOOKUP(Nights,PricePerNight,3) - this is the origional price

VLOOKUP(Nights,PricePerNight,3)*IF(F10="yes",Constants!B15,0) - this bit is one discount and is being taken of the original price

VLOOKUP(Nights,PricePerNight,3)*VLOOKUP(NumberOfCats,CatDiscount,2) - and this part is another discount that is being taken off the original price

my problem is it takes the two discount off but added together for example discount 1 is 10% and discount 2 is 15% it takes off 25% instead of 10% of original price and then 15% from that

anyone got any ideas on how to fix it thanks
=VLOOKUP(Nights,PricePerNight,3)-VLOOKUP(Nights,PricePerNight,3)*IF(F10="yes",Constants!B15,0)-VLOOKUP(Nights,PricePerNight,3)*VLOOKUP(NumberOfCats,CatDiscount,2)

for some reason the formulae didnt display
 
Back
Top