math functions in a drop down menu?

C

curiousgeorge

How do you create multiple math functions in a drop down menu? Eg: weekly,
bi-weekly, monthly payments in a drop down menu to create different
calculations in another cell?
 
T

Toppers

Try:

Putting the formulas for your calculations in named ranges e.g
"Weekly","Bi_Weekly"

Let's say the drop down is in A1

Then in B1 put =EVAL(A1)

HTH
 

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

Font drop-down menu very slow 0
How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
Create own tool bar Mac 2015 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Drop down lists in seperate columns 5
Creating a Dropdown that is Related to the Value Given in Another Cell 6

Top