Results 1 to 10 of 10

IF, AND, OR Help

Threaded View

  1. #1
    Registered User
    Join Date
    12-24-2014
    Location
    albany ny
    MS-Off Ver
    2010
    Posts
    18

    IF, AND, OR Help

    Travel Template.xlsxSo this post is actually based on a previous post of mine... But now the issue has been complicated further.

    Here's what I need:
    AT costs $2.50/mile and has a $25 fee for loading wheelchairs (WC) or scooters (SCOOTER)
    CD costs $5.00/mile and has a $75 fee for loading wheelchairs or scooters
    There is no additional loading cost if the vechicle is SEDAN
    VA will cost the same as CD
    If column L says "RT" (Round Trip), I need to double the mileage I enter in column N
    If column L says "OW" (One Way), the mileage in column N remains the same -- whatever value is entered.
    There is a possibility that Columns A and C will be different carriers (either both CD, both AT, or a combination)

    Can anyone help me with this? Here is the previous formula I was using:
    =IF(AND(L7="RT",OR(M7={"WC","SCOOTER"})),150+5*N7,IF(AND(L7="OW",OR(M7={"WC","SCOOTER"})),75+5*N7,2.5*N7))

    This does not take into account that AT and CD cost different amounts for mileage.

    I attached the spreadsheet if that helps... THANK YOU!!!!
    Last edited by tenglish01; 01-28-2015 at 02:47 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