Results 1 to 17 of 17

Formula to calculate price for hotel room upgrades

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    Germany
    MS-Off Ver
    2008 Excel for mac
    Posts
    4

    Formula to calculate price for hotel room upgrades

    Hi all!
    Working on a sheet that will do automatic upgrades of hotel rooms .
    SO my chart looks like this:
    A B C D E
    1Original room Category Desired room Categorie Price
    2112 E 345 A ?

    So I have made a chart (on a different worksheet) with all the categories and their prices that looks like this:
    A B C D E F G .....
    Cat E D C B A
    1 E 0 90 100 134 200
    2 D 90 0 10 44 110
    3 C 100 0 0 .......
    And so on.

    So I need to find a formula that will look for the original category to the one I want to upgrade to and tell me the price.

    Any suggestions? Can somebody help? Thanks!
    Last edited by Uplate; 03-12-2013 at 05:24 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