I want to create a formula that varies dependent upon what is entered in a drop down box. The drop down will include 2 options, dollar or percentage (d1 below). If i select percentage i want the formula to take the entered value in my example (d3 below shown as $500 in my example) and muliply it by the percentage (b3 below shown as 30 in my example). If i select dollar it will simply take the value as entered in (b3 below). Any help is appreciated.
.A..............B.............C.............D.................
1..........................................................$ or % drop down
2............. Contribution...................................
3..............Single........30.....................$500...................
4..............Family.......30......................$1,000...................
.A..............B.............C.............D.................
1..........................................................$ or % drop down
2............. Contribution...................................
3..............Single........30.....................$500...................
4..............Family.......30......................$1,000...................