EXCEL drop down list.. 2003

[CadMaster]

i know how to add a drop down list (using validation).. but i am having a problem adding a formula to it... i want the drop down list to display "25% OF TOTAL, 50% OF TOTAL, 75% OF TOTAL, 100% OF TOTAL"... than when one of those 4 are selected... it automatically finds that value in the cell where the total is, multiplies it times .25, .5, etc.. then puts in that dollar amount in the cell..

thanks for the help
tony

 

[Kurupt55]

Data validation only returns the result of the cell.
I would make a table with the values that you want in the first column
25% OF TOTAL
50% OF TOTAL
75% OF TOTAL
100% OF TOTAL
Then in the next column put the formulas that you want it to return
=A1*.25
=A1*.5
=A1*.75
=A1
Name your first column "LIST" and this will be used for your data validation
Then select both columns and name the range "DATA"
in the cell next to your drop down list use a VLOOKUP to return the result that you want
=VLOOKUP(B1,data,2,FALSE)
Hope this helps

Impossible is Nothing