Looking up a table value based on two conditional option buttons

  • Thread starter Thread starter Pristan
  • Start date Start date
P

Pristan

I have a table of percentages from which I need to output a single percentage
as part of a pricing equation. This single number is chosen by selecting the
contract volume (row) and the contract length (column). My sales reps input
the contract volume and length by selecting OptionButtons in another
worksheet within this workbook.

Can I code a macro to take the selections from those two OptionButtons,
select the corresponding percentage, and output it for use in my pricing
equation?
 
I have a table of percentages from which I need to output a single percentage
as part of a pricing equation. This single number is chosen by selecting the
contract volume (row) and the contract length (column). My sales reps input
the contract volume and length by selecting OptionButtons in another
worksheet within this workbook.

Can I code a macro to take the selections from those two OptionButtons,
select the corresponding percentage, and output it for use in my pricing
equation?
Click to expand...

sure. we would need more specifics to tell you how to code this. Also,
this seems like something that could be done with standard formulas
within excel, without the need for a macro.
 
I am new to VBA so it is very possible this could be done without macros so
either way I can set it up will be fine with me.

I've included an example of what I'm working with below. The contract price
is calculated by multiplying the unit price, volume, discount % and the # of
years in the contract all together. It's not complicated however I'd like to
keep the form with OptionButtons on one sheet and the calculation on another
sheet.

Currently the salesforce would select the # of years on one button and the
volume on another. I'd like those two selections to output the corresponding
% to another cell for calculating the contract price.

Years
1 2 3 4
Volume 5000 100% 95% 90% 85%
10000 80% 75% 70% 65%
15000 60% 55% 50% 45%
20000 40% 35% 30% 20%

Contract Price $18,750

Unit Price $2.50
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Edit cell based on position of option button clicked. 3
Button Sort Macro Not Working 3
checking if a combiantion of values exists on a different row 2
copy updated table values to a "summary" worksheet 1
Macro to Loop through and sort worksheets 4
Return value based on certain criteria 3
String search on two tables 1

Back
Top