from C17 to B15 use nested IF to display shiping cost

May 25, 2013 at 20:37:37
Specs: Windows 7
in cell C17, use nested IF funtions to display the shipping cost for the option entered in cell B15.
I'm confused because I am not sure what to type in, in the Logical test area. I typed in shipping options and it was invalid.

See More: from C17 to B15 use nested IF to display shiping cost

Report •

May 29, 2013 at 10:17:19
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.

Report •

May 29, 2013 at 12:55:15
If the IF function is going to rely on the value manually entered into a given cell, I suggest that you use a data validation drop down list.

You just can't trust those pesky users to type the exact text string that the IF function is looking for.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question