Data validation to percent discount, Help

[Squirrel8056]

I am doing a membership formula to calculate their rate they pay and how much they have paid to total out to how much they still owe. We give a 10% discount if have purchased a memership before the new year.

[TABLE="class: grid, width: 500, align: center"]
<TBODY>[TR]
[TD][/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]i[/TD]
[TD]j[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Rate type[/TD]
[TD]full price[/TD]
[TD]10% discount[/TD]
[TD]customer price[/TD]
[TD]paid[/TD]
[TD]owe[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]INIVIDUAL MEMBER[/TD]
[TD]$700.00[/TD]
[TD]YES[/TD]
[TD]$630.00[/TD]
[TD]$430.00[/TD]
[TD]$200.00[/TD]
[/TR]
</TBODY>[/TABLE]




I used a data validation list for the rate type and =VLOOKUP to get the FULL PRICE. I used another data balidation for the YES OR NO for the discount. I am lost after that i think im over thinking it. I have been trying a =IF fomula to get if the customer has the 10% discount or not. looks like this =if(g7=YES,[f7*.9],[f7]). is there a different fomula to do this formula or is the IF formula the right way to do this

 

[skiumah]

If instead of YES you use logical TRUE in G7, you could just put the following in H7:

=F7-(F7*G7*0.1)

So, if G7 is FALSE, the quantity in parentheses is zero and no discount is taken.

 

[Skybluekid]

The formula you have used is quite suffceint and easy. I would use "" around YES.

 

[iyyi]

=if(g7=YES,[f7*.9],[f7])

Almost...
=if(G7="YES",F7*0.9,F7)

 

[Squirrel8056]

So i cannot just select individual member from the data validation to show 700 then select yes or no for it to bring the percent into effect?

 

[Squirrel8056]

Thank you, yea i just needed that quotation marks

 

[Skybluekid]

Does this help

https://www.dropbox.com/s/tnfvfdk8iwa7g5y/Data.xlsx