|You haven't really given me enough information to really know for sure what you want, but here's a shot in the dark. You will obviously need to change the values to better fit your needs...|
IF Syntax: IF(logical_test,value_if_true,value_if_false)
From Excel: Checks whether a condition is met and returns one value if TRUE and another value if FALSE.
Assuming there are three shipping options ("2-Day", "5-Day" and "10-Day")
Copy and Paste formula below into C17.
=IF(B15="2-Day", "Shipping: $19.99", IF(B15="5-Day", "Shipping: $9.99", IF(B15="10-Day", "Shipping: $1.99", "Please enter Shipping Type")))
If B15 is blank or has any other text besides "2-Day", "5-Day" or "10-Day" C17 will say "Please enter Shipping Type." If you type "2-Day", "5-Day" or "10-Day" the appropriate cost that is defined in the formula will show up in C17.
Law of Logical Argument: Anything is possible if you don't know what you're talking about.