+ Reply to Thread
Results 1 to 4 of 4

Noobie needing basic calculation help

  1. #1
    Registered User
    Join Date
    09-16-2015
    Location
    newcastle
    MS-Off Ver
    office 2010
    Posts
    1

    Noobie needing basic calculation help

    Hi

    This is the start of what will probabily be a very long journey for me.

    I am trying to make what seems to me a very basic for for my website but first I need to create a working excel sheet for it.

    I would like two fields

    distance in miles
    and type of delivery

    The choices for delivery on my form will be moped , power bike , small van , large van

    I would like the calculator to take the number of miles entered eg 200 to be multipled by eg 2
    then a percentage added depending on the second outcome eg van 10% large van 20% moped 0%

    Is this even possible

    Thanks in advance.

    Any links for further reading are most welcome.

    Davie

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Noobie needing basic calculation help

    Perhaps this will get you started in the right direction. With a lookup table in E1:F4 this. I just made up some calculations to demonstrate the basic idea.

    This would be a good place to learn about the VLOOKUP function used here.

    http://contextures.com/xlFunctions02.html

    Does this help?

    Row\Col
    A
    B
    C
    D
    E
    F
    1
    Distance Type of Delivery Van
    10%
    2
    200
    Large Van
    40
    In C2 :=VLOOKUP(B2,$E$1:$F$4,2,FALSE)*A2 Large Van
    20%
    3
    154
    Large Van
    30.8
    Moped
    0%
    4
    25
    Power Bike
    3
    Power Bike
    12%
    5
    32
    Van
    3.2
    6
    12
    Moped
    0
    Last edited by FlameRetired; 09-16-2015 at 10:45 PM. Reason: link inclusion
    Dave

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,001

    Re: Noobie needing basic calculation help

    "FlameRetired" reply beat me to it!!
    Last edited by JohnTopley; 09-16-2015 at 10:55 PM.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Noobie needing basic calculation help

    Quote Originally Posted by JohnTopley View Post
    "FlameRetired" reply beat me to it!!
    Finally.... LOL

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Noobie needing Accounting help
    By Butcherdeliz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2015, 03:39 AM
  2. [SOLVED] Basic Calculation of Start - End Time
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2015, 02:29 PM
  3. Needing an auto-sort macro from MIN calculation
    By The Navster in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-23-2014, 01:00 AM
  4. Newbie needing help to writing a basic iif formula
    By masond3 in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-21-2014, 09:30 AM
  5. [SOLVED] Basic Calculation Help
    By Chrissyamcnally in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-25-2012, 12:50 PM
  6. Excel Error in Basic Calculation
    By WAW in forum Excel General
    Replies: 1
    Last Post: 09-14-2011, 11:29 AM
  7. Newbie needing help with basic macro!
    By davering in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-24-2008, 08:23 AM

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