23:07 < Twoods196> Anyone mind helping me with a formula im trying to write in excel?
23:09 < Prune_> show the formula, woods, and explain what you're trying to do with it.
23:10 < Twoods196> ok, Ponder this:
23:10 < Twoods196> Say you are asked to figure out how many tables you need for the party next weekend... 60 people, each table "A" seats 4 each table "B" seats 6 how many of each
23:10 < Twoods196> i know the answer is 6 for both
23:10 <+Krazylegz> You want the same number of A and B tables?
23:10 < Twoods196> but how would I write a formula for excel to figure this out and still be correct if 60 was to change
23:11 <+Krazylegz> What if you only need 1 more table? Do you get an A table or a B table?
23:11 < Prune_> ok woods
23:11 < Twoods196> Well I know 6 of a is 24 and 6 of b is 36 and 36 +24 is 60
23:12 < Prune_> people # can change, what about the tables, do they change?
23:12 < Twoods196> no tables do not change
23:15 < Prune_> then what's to solve?
23:15 < Twoods196> how many of a and b is need to accomadate the people
23:16 < Prune_> but you said tables do not change....can the number of tables change?
23:16 < Twoods196> yes, but the number they seat can not is what i meant
23:17 < Prune_> ok now I understand now you claarified
23:17 < Twoods196> yea sorry
23:21 < Prune_> i'd have more ideas but my IQ goes down at sunset
23:23 <+Krazylegz> So you have 60 people.
23:23 <+Krazylegz> The formula tells you that you need 6 A tables and 6 B tables.
23:23 <+Krazylegz> 6 * 6 + 6 * 4 = 60.
23:23 <+Krazylegz> How many A and B tables do we need if we have 61 people?
23:24 < Twoods196> see thats my problem...i could write one that worked with 60 people only
23:24 < Twoods196> but if it changed that formula wouldnt work no more
23:25 <+Krazylegz> Okay...what do you want it to do?
23:25 <+Krazylegz> We are building the correct formula.
23:25 <+Krazylegz> But you have to tell me what the formula should output.
23:25 < Twoods196> should output the number of tables needed to accomade the people
23:25 <+Krazylegz> Which would be what, for 61 people?
23:25 < Twoods196> and it cant be just 10 B Tables
23:26 <+Krazylegz> What is the correct answer for 61 people?
23:26 < Twoods196> Well I guess you would have to added and extra a table
23:26 <+Krazylegz> Okay, so an A table.
23:26 < Twoods196> i get wut your saying though
23:27 <+Krazylegz> And if I need to seat 67 people?
23:27 <+Krazylegz> Then I would have 7 A tables and 7 B tables?
23:27 <+Krazylegz> Or 6 A tables and 8 B tables?
23:27 < Twoods196> yeh