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

Report
Posts
1
Registration date
Friday October 25, 2013
Status
Member
Last seen
October 25, 2013
-
 Blocked Profile -
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 reply


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