Conditional Formulas

[Louise]

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?

 

[David Biddulph]

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]

 

[PCLIVE]

Maybe something like this:

=IF(OR(A1="100 pcs",A1="100 ft"),B1/100,IF(A1="1,000 ft",B1/1000,"What
should happen if there is no match?"))

Note, you didn't specify what should happen if there is not a match. I also
assumed that the third condition should be devided by 1000.

Does that help?
Paul

 

[BRob]

Let's assume you use row 2 then in c2 put in something along the lines

=IF(B2="100 pieces",A2/100,IF(B2="100
ft",A2/100,IF(B2="1000pcs",A2/1000,"")))

What is in each of the "???" has to be exactly what it is in your look
table - the last "" just gives a blank cell.

If your look up table only contains numbers then you probably don't need a
conditional formula - it would be a straight division

Hope this helps

 

[Louise]

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

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

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]

Paul thank you so much. I had to make a couple of adjustments but your
formula was just what I needed. Here's the final formula:

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

Just had to change a column letter. Yes you were right about 1,00 was
supposed to be 1,000. Didn't need anything for "no match". There will
always be something there.

Again thanks.

 

[Louise]

I already got and answer from Paul:

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

But thank you for taking the time to help me.
--
Louise

Let's assume you use row 2 then in c2 put in something along the lines

=IF(B2="100 pieces",A2/100,IF(B2="100
ft",A2/100,IF(B2="1000pcs",A2/1000,"")))

What is in each of the "???" has to be exactly what it is in your look
table - the last "" just gives a blank cell.

If your look up table only contains numbers then you probably don't need a
conditional formula - it would be a straight division

Hope this helps

 

[PCLIVE]

Please note that your third condition appears to have an error.
I believe you meant:

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

You had the 1, outside of the quotes. You still may want to address the
false condition if there is no match.

HTH,
Paul

--

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

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

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?

 

[PCLIVE]

Disregard my reply on your other post. You just stated that there will
always be something there.

Glad to help.

--