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

GrimmLynne Posts 1 Registration date Friday October 25, 2013 Status Member Last seen October 25, 2013 - Oct 25, 2013 at 12:28 PM
 Blocked Profile - Oct 25, 2013 at 01:13 PM
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?

1 response

Blocked Profile
Oct 25, 2013 at 01:13 PM
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:

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.