I am attempting to create my first "conditional" formula for a quote form
and am at a loss.

Column A is the total quantity wanted
Column B has a drop down menu with the options of 100 pcs, 100 ft, or 1,000 ft
Column C needs to have a formula that says:

if column b = 100 pcs then column a s/b divided by 100 and the sum entered
here.
if column b = 100 ft then column a s/b divided by 100 and the sum entered
here
if columb b = 1,000 ft then column a s/b divided by 1,00 and the sum
entered here

Can anyone out there help me with this?

--
Louise