Connecting a formula to a combo box

[roxdrob01]

Hi, I'm trying to set up a formula based on the value in a combo box and it's not working. What am I doing wrong?

[samba_ravi]

Please tell me the List of Items you have in ComboBox as it appear in combobox, in your attached file I am unable to see the list in combobox.

[roxdrob01]

(blank)
Mark
Roxanne
Joint

[samba_ravi]

ok instead of using the text use numbers in as per their order

d3=IF(B3=1,0,IF(B3=2,C3/2))

e3=IF(B3=2,0,IF(B3=1,C3/2))


here 1 means Mark, 2 means Roxanne and 3 means Joint
Note: The order which they appear in combobox
you can find the number in B3 by dragging the Combobox towards Up/down, when you select the list in combobox, the number in B3 will be changed based on your selection

[roxdrob01]

yeah, I didn't finish the formula. I was trying to get that part to work. It doesn't.

[roxdrob01]

=IF(B3="Mark",0,IF(B3="Roxanne",C3/2,IF(B3="joint",C3/2,"error")))

This is the new formula

[samba_ravi]

see the post no 4, I modified the post

[roxdrob01]

ok. I got it. Thanks. Is there any way that is easy to copy the combo down for several rows or do I have to set each one up?

[samba_ravi]

I think you can use Data Validation instead of Combobox

see the attached file,
here you can use If condition as you used before

[roxdrob01]

Thank you. That's awesome. I didn't know about that. I copied yours, but need to figure out how to do it on my own.

[samba_ravi]

data > datavalidation>settings>select list from allow > in source you can type the names or can select the range

If you want to enter names your own, "" not required as you used in formulas for text and the list will be separated by ,

[roxdrob01]

thank you. I found it and set it up. That's a cool function. Thanks so much!