Paul already answered me with the perfect formula:

=IF(OR(B14="100pcs",B14="100ft"),A14/100,IF(B14=1,"000FT",A14/1000))

To clarify my e-mail by "s/b" I meant should be

Thank you for taking the time to respond to me.
--
Louise


"David Biddulph" wrote:

I don't know what you mean by "s/b", but try
=IF(B2="1000 ft",A2/1000,A2/100)

[... assuming that by a s/b divided by 1,00 you mean a divided by 1000]
--
David Biddulph

"Louise" wrote in message
...

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