what i want to do is create a form in excel that would allow a user in a
different state to calculate how much thier state taxes would affect thier
pay.

for example user A lives in Chicago, so he goes to the sheet enters his
salary in the salary box, then there is a drop down that shows the different
cities and then chooses Chicago and the result at the bottom shows how much
his deductions from taxes are. if someone could point me in the right
direction i'd appreciate it.

thanks,

hi Liju

Use the Vlookup formula to search for the taxes
See Debra's site for examples
http://www.contextures.com/xlFunctions02.html

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Liju George" wrote in message ...
what i want to do is create a form in excel that would allow a user in a
different state to calculate how much thier state taxes would affect thier
pay.

for example user A lives in Chicago, so he goes to the sheet enters his
salary in the salary box, then there is a drop down that shows the different
cities and then chooses Chicago and the result at the bottom shows how much
his deductions from taxes are. if someone could point me in the right
direction i'd appreciate it.

thanks,