List Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the list box with the information in it.
When I click on let say Weekly I want a cell in the spreadsheet to
If(ComboBox1 = Weekly, Sum(C20*5),0)

How do I get this to work?


Thanks
Chey
 
How did you make the combobox?

Did you use a combobox from the Control toolbox toolbar?
Did you use a dropdown from the Forms toolbar?
Did you use data|validation?
 
Control Tool Box

Dave Peterson said:
How did you make the combobox?

Did you use a combobox from the Control toolbox toolbar?
Did you use a dropdown from the Forms toolbar?
Did you use data|validation?
Click to expand...
 
Go into design mode.
Show the properties for that combobox
Change the LinkedCell property to the address of a cell (out of the way or under
the combobox???)
then use that linked cell in your formula.

=If(a1="Weekly",C20*5,0)
(A1 is my linked cell)

You need double quotes around strings and you don't need =sum() in your
expression.
 
I think I may be a little confused
In my combo box I have the following choices
Weekly
Every 2 Weeks
Twice Monthly
Monthly

When i linked the cell I linked it to H21
When I choose drop down it changed my cell to Weekly or whatever I choose.

Do I put the formula in H21 or in the combo box properties?

What I need is
Weekly (C20*4.3)
Every 2 Weeks (C20*2.15)
Twice Montly (C20*2)
Monthly (C20*1)

Thanks so much for your help

Cheyenne
 
The linked cell is only going to contain the value of the combobox--not a
formula.

So you can use this formula in any other cell (not H21, not C20).

=C20*IF(H21="weekly",4.3,IF(H21="every 2 weeks",2.15,
IF(H21="twice monthly",2,IF(H21="monthly",1,0))))

(all one cell)

And I used "twice monthly" with a difference in spelling.

This formula is equivalent:
=C20*(((H21="weekly")*4.3)+((H21="every 2 weeks")*2.15)
+((H21="twice monthly")*2)+((H21="monthly")*1))

And doesn't use the =if()'s.


I think I may be a little confused
In my combo box I have the following choices
Weekly
Every 2 Weeks
Twice Monthly
Monthly

When i linked the cell I linked it to H21
When I choose drop down it changed my cell to Weekly or whatever I choose.

Do I put the formula in H21 or in the combo box properties?

What I need is
Weekly (C20*4.3)
Every 2 Weeks (C20*2.15)
Twice Montly (C20*2)
Monthly (C20*1)

Thanks so much for your help

Cheyenne
Click to expand...
 
Back
Top