Link the combox to a cell, and then just use a simple lookup

=A2*LOOKUP(A2,{25,30,40},{3.85,4.25,2.75})

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"rdwngr23" wrote in message
...
how can i get a specific value in a cell based on what is marked from a
checkbox?

if i have a combo box with 25, 30, 40 in cell b2 and i want cell b3 to
calculate a formula based on the "25" being checked (ie: if "25" is
checked
multiply that (25) by 3.85)

am trying to use this for a home business - need help please!!!