

Jan 11, 2013, 08:52 AM  

We've got fog so thick I can't see the end of my driveway...and the blower motor on my furnace took a dump last night...the furnace is 30 years old, and we already started looking at a new furnace last year, so we may have to go ahead with that now...I don't think replacing a blower motor on a 30yr old system is a good plan. There goes my airplane money for this spring
Temps are in the 40's right now, but will go back to the 20's in a few days; hope I can get the furnace repaired/replaced quickly! :O 
Jan 11, 2013, 12:55 PM  

Howdy kids
Snowman Nice catches sounds like a a great meal or 6 is coming. <<<<(pretend thats fish nuggets) I just pulled out the ol Raider from Last year to repair I must have packed it up in a big box for a house showing but I forgot I even had it and came across it yesterday I was like OH Yeah I have to glue this baby back together from Our Snowman waldo day at the field DOH!!!! so thats the project I'm starting with, I really missed flying that all last season I must have too many toys lol Brathanke that was a weird story LOL for her to just keep pulling away with that screeching sound like claws on a chalkboard slowly and painfully panicking in the car knowing there was no way she was getting off this accident with you right in the car. watching in disbelief... wow Wookster wheres the After photo LOL Good luck on the Stick Wayne MATH TEST And FUNCTION in Excel 2007 Question I figure i come to this place and find out any answer to pretty much anything so Here is a doozy thats been driving me out of my Mind for Days We have a computer that by putting a box on a scale reads how many pounds the box is then charges the correct price for the weight. I designed (Well Discovered) the correct formula to work for this system, Well they want to change it and I can't get a newer formula to work here is the original formula which goes in Cell D1 =IF(A1>10,(A110)*(0.15)+B1,4.10) The Cell A1 is open to type in any number you want The Cell B1 contains the constant number $4.10 The Cell C1 is just a space between the numbers and the total in D1 So to try this out to make sure the function is working, Put the formula in D1 and put 4.10 in B1 then type in any number in A1 the total will appear in D1 A1 B1 C1 D1 11 $4.10 $4.25 The problem After 35Lbs we need the formula to repeat itself, and then 70lbs then 105lbs Etc So I would think something like this (Note the bold print) =IF(A1>10,(A110)*(0.15)+B1,4.10),IF(A1>35,(A110)*(0.15)+B1,4.10)*2 well this is not the answer When the formula works it should look like this: for the 1st 10 Lbs the cost is $4.10 Then every additional lb after 10lbs is $0.15 more 35lbs should cost $7.85 3670lbs should cost $15.70 71105lbs should cost $23.55 If anyone knows anything about this HELLLLLLLLPPPPPP I'm losing valuable hair here I've been to the excel help sites and can't find what i'm looking for and then it hit me The T_ _ _taholics Love a good challenge 
Jan 11, 2013, 01:04 PM  

Waldo it doesn't look like you are far off. Let me chew on it for a few minutes.
edit: One thing I can tell right away is that your first if statement has been completely closed with a ")" before you start the second logical test. For a nested If to work correctly you have to leave that open. Delete the closing parenthesis and you will be closer to your goal. 
Jan 11, 2013, 01:29 PM  

Waldo, I need some clarification... is it a flat rate all the way from 3670 pounds or does it increase incrementally up to the 23.55 spot at 71 pounds? I have a formula working up to the 35 pound mark but I'm just uncertain about the logic you are trying for from there. I'm going to continue to work on it based on the idea that increases per pound.

Jan 11, 2013, 02:04 PM  

Quote:
How much does 1134 pounds cost? Should the desired solution read as follows? for the 1st 10 Lbs the cost is $4.10 1135lbs should cost $7.85 3670lbs should cost $15.70 71105lbs should cost $23.55 or should it be this: for the 1st 10 Lbs the cost is $4.10 Then every additional lb after 10lbs is $0.15 more 11lbs should cost $4.25 12lbs should cost $4.40 30lbs should cost $4.10 * (20 * $0.15) = $7.10 ....etc... 35lbs should cost $7.85 3670lbs should cost $15.70 71105lbs should cost $23.55 what should be the charge for 55lbs? is there any upper limit on weight? 

Jan 11, 2013, 02:20 PM  

Thanks guys This thread is just the most Awesome thread in the world. Bar non we should be a University for God's sake TUOA
T_ _ _Taholics University Of America. Just got off the phone with Brathanke as he has been working the numbers for me, and we're getting closer, It was great to actually hear is voice on something other than a video Snowdog Thanks also and This is correct Quote:
so 36 lbs would start the formula all over again, so by the time you got to 70Lbs the total would double. every 35lbs to infinity they want the formula to start over again. 

Jan 11, 2013, 03:00 PM  

Quote:
If you don't have Office 2010 (and therefore support for .xlsx files) let me know and I will convert it to a standard .xls file. That was fun! 

Thread Tools  
Similar Threads  
Category  Thread  Thread Starter  Forum  Replies  Last Post 
Discussion  New Club Thread  Northern Beaches Soaring Club  Psionic001  Australia  5  Feb 24, 2011 08:19 PM 
Help!  Tower SUper Saver Club  la528it  Hot Online Deals  9  Jan 10, 2010 05:48 PM 
Discussion  San Francisco Model Yacht Club's multiclub Swap Meet  craig_c  Dock Talk  17  Oct 13, 2009 02:28 AM 