+ Reply to Thread
Results 1 to 2 of 2

Creating switches

  1. #1
    Registered User
    Join Date
    01-08-2006
    Posts
    30

    Question Creating switches

    senario:
    I have a simple booking form but i have three charging tariffs simple cacls tell me the cost based on the hours this is achived by manually inserting a refrence cost,
    for instance:
    the hirer wishes to hire a hall fore 3 hours @ 8.50 p/h total 25.50 this is my band (A) tariff now i would like this total (25.50) to be placed into colum A on sheet 2 and so on band (B) & (C) it does not matter if a separate entry is entered on each booking or they are added together giving a single total in each of the tariff colums. By selecting either one of the tariffs on booking form (sheet A) i want the result total to be placed ind corisponding colum on sheet 2

    also is there a way of selecting the charging tariff instead of manually entering each time as i feel they may be linked
    IE: list box ect

  2. #2
    Tom Ogilvy
    Guest

    Re: Creating switches

    Use a formula.

    Use Data validation.

    See previous answers.

    --
    Regards,
    Tom Ogilvy


    "kevatt" <kevatt.22gvob_1138656901.7923@excelforum-nospam.com> wrote in
    message news:kevatt.22gvob_1138656901.7923@excelforum-nospam.com...
    >
    > SENARIO:
    > I have a simple booking form but i have three charging tariffs simple
    > cacls tell me the cost based on the hours this is achived by manually
    > inserting a refrence cost,
    > *for instance:*
    > the hirer wishes to hire a hall fore 3 hours @ 8.50 p/h total 25.50
    > this is my band (A) tariff now i would like this total (25.50) to be
    > placed into colum A on sheet 2 and so on band (B) & (C) it does not
    > matter if a separate entry is entered on each booking or they are added
    > together giving a single total in each of the tariff colums. By
    > selecting either one of the tariffs on booking form (sheet A) i want
    > the result total to be placed ind corisponding colum on sheet 2
    >
    > also is there a way of selecting the charging tariff instead of
    > manually entering each time as i feel they may be linked
    > IE: list box ect
    >
    >
    > --
    > kevatt
    > ------------------------------------------------------------------------
    > kevatt's Profile:

    http://www.excelforum.com/member.php...o&userid=30245
    > View this thread: http://www.excelforum.com/showthread...hreadid=506547
    >




+ Reply to Thread

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