Results 1 to 2 of 2

Is there a formula to return data dependant on data submitted in 3 different Cells?

Threaded View

  1. #1
    Registered User
    Join Date
    10-31-2012
    Location
    Bristol
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy Is there a formula to return data dependant on data submitted in 3 different Cells?

    Can Anyone help me??

    Im looking to put in a formula for a mileage claim form.
    The form has the vehicle type, fuel type & capacity and depending on what you drive depends on the amount you can reclaim so I want the mileage rate to default automatically once those 3 cells are filled in.
    Also if you have a passenger you get an extra 5p per passenger per mile so ideally Id like to encorporate this into the formula.

    Apologies if this is a really basic formula, Im self taught on formula's so this one is just getting me a bit confused.

    Any help will be greatly received
    Last edited by Nats123; 10-31-2012 at 10:15 AM.

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