Results 1 to 9 of 9

Help getting my syntax correct

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    McKinney, TX
    MS-Off Ver
    Excel 2007
    Posts
    5

    Help getting my syntax correct

    I am calculating shipping charges in Excel 2007.

    A1 is a drop down box with two options: Standard shipping and Priority Shipping.

    I need to calculate based on two conditions:

    If "Standard Shipping" is selected and the # of items (B1) is <=5, then the shipping charge (C1) = $5.00.

    I need to nest this for 4 different values for B1 AND for Standard Shipping and Priority Shipping. I could also use two check boxes instead of the drop down if that would be better.

    I just can't seem to get it right.
    Last edited by MMS6300; 02-20-2009 at 02:23 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1