Results 1 to 17 of 17

Formula to calculate price for hotel room upgrades

Threaded View

Uplate Formula to calculate price... 03-10-2013, 08:29 PM
tgsekhar Re: Formula to calculate... 03-10-2013, 10:42 PM
FDibbins Re: upgrades 03-10-2013, 11:33 PM
Uplate Re: upgrades 03-11-2013, 06:59 PM
wraithlet Re: Formula to calculate... 03-11-2013, 08:20 PM
Uplate Re: upgrades 03-12-2013, 03:52 AM
wraithlet Re: Formula to calculate... 03-12-2013, 01:09 PM
Uplate Re: Formula to calculate... 03-13-2013, 02:42 AM
dredwolf Re: upgrades 03-12-2013, 04:00 AM
Fotis1991 Re: upgrades 03-12-2013, 04:17 AM
arlu1201 Re: upgrades 03-12-2013, 04:28 AM
Fotis1991 Re: upgrades 03-12-2013, 04:48 AM
arlu1201 Re: Formula to calculate... 03-12-2013, 05:55 AM
Fotis1991 Re: Formula to calculate... 03-12-2013, 06:12 AM
FDibbins Re: Formula to calculate... 03-12-2013, 01:16 PM
wraithlet Re: Formula to calculate... 03-12-2013, 02:52 PM
dredwolf Re: Formula to calculate... 03-13-2013, 03:02 AM
  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 2 users browsing this thread. (0 members and 2 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