Wednesday, November 15, 2017

yogi_Compute Fee For Services Based on Multiple Parameters

Google Spreadsheet   Post  #2290

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-15-2017
question by: mattynew
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/dP57xuWxsSI;context-place=topicsearchin/docs/authorid$3AAPn2wQc7O4EQsX1gkj1mKYiVqjACnXxOUJfDW9aP6REEoSb26rzIBkrBhpHOgIm3cS21f6-y3rVl%7Csort:date%7Cspell:false
I don't know if the formula I am looking for exists...
Good afternoon everyone,

I hope you are all having a good day. I apologise in advance if I appear to becoming across lazy - while some of that is true, I have tried over and over but can't seem to get my head around the formula I should be using. I thought maybe 'lookup', vlookup etc might be right but I can't figure out the actual formula.


Above is the link to the sheet I am currently working on. (its view only but happy to adjust it to anyone who thinks they can help).

Heres what I currently have formulated: (by tab)

Input data: This is where I want to be able to punch numbers in and have the desired results pop up so no one has to leave this tab to find the answers they are looking for. 

Where I need help is the 'Fincas cleaning earnings', 'cleaning fees' and 'owners earnings' (currently no formula put in these cells)

Basically, when a number is put into the 'number of guests' cell and 'number of nights' cell, I would like a formula to grab the information from the following cells:

Fincas cleaning earnings: When a number is input into 'number of guests' and 'number of nights', is there a formula that can grab the information from the tab 'cleaning fees'. For example, if 2 people stayed 4 nights then the figure should equal: small - $80 for small / $130 for medium / $180 for large

Owners earnings: When a number is input into 'number of guests' and 'number of nights', is there a formula that can grab the information from the tab 'Net Rental minus F.P.P.H minus Cleaning fees'. For example, if 2 people stayed 4 nights then the figure should equal: small - $480 for small / $430 for medium / $380 for large

In theory it should be possible but I've totally lost it trying to figure it out. Any help will hugely appreciated. I live in the jungle so only have internet access when at basecamp, apologies in advance for any delayed response. 

Thank you so much

Matt