What the next lowest amount will be only using the 1,2 or 4 person $ amounts

Hi I have a simple spreadsheet I'm trying to formulate, however i can't seem to work out what formula to use or even what it is called to search for it, see attached (I hope it attached)

Please verify in this file.


Regards.

dingo, Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Originally Posted by menem

Please verify in this file.


Regards.

Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

Dear FDibbins.

I'll try my best to explain my solution (with my poor English >_<" ).

First of all , requester didn't know what formula or calculation condition to get the answer,
so he just give all result in value on the form (as attatch image).

After look in his form & data I try to figure out what it is base on (or come from) and think that
it might comefrom price of ticket calculation & calc for % give to other party.

Then begin with 1 / 2 / 4 people (ticket at once) result is 10, 19, 35
it's mean they might have a discount for 1+ people : 1 = 10 and 2 must be (10 - discount ) x 2)
and I guess it is 0.5 per ticket so price might be (10-0.5) x 2 and it correct and so for 4 people
discount is 1.25 = (10 - 1.25) x 4

** from this point I don't enter to enter discount directly in cell formula because of change it's
value vary.

then for next column is alson in the same way , (guess for market fee %, and gts credit %)
finally it stop at 30% market fee, 3% gts credit

Then formula on each cells is

C10
=$A10*C$2
while $A10 = number of ticket , C$2 = ticket price each ( for other volumn price will change from discount : G and K )

D10
=C10*D$2
while C10 is from (number of ticket x amount at once) , D$2 = market fee % (30% fixed)

E10
=ROUND(C10*E$2,2)
while C10 is from (number of ticket x amount at once) , E$2 = gts credit % (3% fixed)

F10
=C10-D10-E10
(number of ticket x amount at once) - market_fee - gts_credit


Regards.

Originally Posted by Dingo4nsw

Hi FDibbins,

I'm sorry, but I Don't understand what I am to change, as I don't even know what to call the formula or discussion?
Regards

What were you trying to achieve? You don't need to know the names of functions to tell us that. Just articulate what you want to get as a result.

@ Dingo, as Ali said, just explain what you need to do, in your own words. We will try and figure out what you need, and how you need to do it

@ menem, there is nothing wrong with your English, you described that very well!! And even if a member does not understand what you say, or how you say it, they can always ask again

Have I changed the title correct?

Also I have another formula I need someone to create for me.

I need to know what the next lowest amount will be only using the 1,2 or 4 person $ amounts?

Use this as your thread title, please: "What the next lowest amount will be only using the 1,2 or 4 person $ amounts".

Will you please attach a small sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

Unfortunately the attachment icon doesn't work at the moment (it hasn't worked for years, and despite our repeatedly asking the technical team who own the forum to fix it, they can't be bothered to do so), so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please change your title as I instructed in post #11.

Dingo.... in effectthe problem is very straightforward. However, the data layout A3 to a10 will make ANY formula extremely complicated!! Is there flexibility here?

With data layout changed:

=SUMPRODUCT((A3:C3)*$F$2:$H$2)