How do I change the formula based on text in another cell...Closed

Question

Example:  In column C, I have either "C&D", "Concrete", "Dirt", or "Asphalt". 

Column D is a weight.

Column E is the weight *$30 for "C&D" only.  I have that one.  For "Dirt" or "Asphalt" it needs to formulate (column D minus 14), then multiple that by $25.

Column F is a flat rate.  For "C&D" and "Concrete" it should = $125.  For "Dirt" & "Asphalt" it should equal $225.

How do I create these formulas based on these conditions?

ac3mark · Answer

Good Afternoon.

The logic for the formula you are looking for is in this format:

=if(logic test, true, false)

So, it would look like this:

cell a1 contains:
50

cell b1 contains:
=if(a1<49,"The value is less than 50","The Value is more than 50")

Cell b1 would now contain "The value  is more than 50".

Please understand, you can nest logical if statements like so:

=if(logical test for test #1,if(logical test for #2,"true to test#2","false to test #2"),"false to test #1")


I hope this helps.


 
//ark
-Contributor

How do I change the formula based on text in another cell...

1 response

Similar discussions

Subscribe To Our Newsletter!