Results 1 to 20 of 20

Calculate price of hotel room according to season

Threaded View

  1. #12
    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
    31,047

    Re: Calculate price of hotel room according to season

    If you can post a file (maybe mine with the updated tariff table) and some examples of the room categories/client categories calculations , then I will look to update the file.

    I did look at the original image but was too idle to input the data into my table!!!

    With regard to the second image: can please provide that is table in Excel. It is very easy to "lookup" such a table given we have Room/Client categories.
    Last edited by JohnTopley; 04-19-2017 at 10:54 AM. Reason: Added more info

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2013 wants to calculate Sales Price , If cost price exits and wants change SP
    By Bitto in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 12:49 PM
  2. Calculate medians by season
    By MAHood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2014, 03:55 PM
  3. [SOLVED] Multiple IF's to calculate price based on cost and add handling charge and round price
    By RoyRose in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-13-2014, 01:18 PM
  4. [SOLVED] Hotel Rooming List, sorted by category of room (Single Double etc)
    By Robert.Appel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2014, 06:17 AM
  5. [SOLVED] Formula to calculate price for hotel room upgrades
    By Uplate in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-13-2013, 03:02 AM
  6. Calculate a total holiday price based upon different nightly room rates
    By bellevue in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-18-2011, 04:34 AM

Tags for this Thread

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