Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Mr Bond
Formula to get the sum of a specifc value in excel ?
Hello friends!
This is what I am looking for... let's say I have a series of values (numbers) and I want to know which combination of those numbers (adding them up) will give me a specific value... does anyone know a formula/table/code/program to do this in excel?
Example:
Numbers: 2, 5, 8, 9, 3, 22, 15, 19.
Issue: Would like to know the addition of which numbers above would give me a total of 17.
Answer: 2 + 15, also 8 + 9
So, is there anything I can do within the excel limits that would let me plug in the numbers above, and then tell it that I would like to know which of those numbers would give me 17?
And if there is already another software that will do this, that would be great too.
Thanks!!
1 AnswerSoftware7 years ago¿Puedo comprar un iPhone 4S de ATT y usarlo con Telcel?
Quiero comprar un iPhone 4S 32GB de AT&T que ya esta deslaqueado en los Estados Unidos, y me lo quiero llevar a Mexico para activarlo con Telcel. Esto si es posible, o tengo que hacer algun tipo de modificacion?
Actualmente ya tengo un numero de telefono en Mexico con Telcel, y tengo el SIM Card, tamano regular. Pero creo que el iPhone use micro-SIM... entonces tengo que comprar otra tarjeta? Si en Telcel me dan otra tarjeta, voy a perder mi numero de telefono?
Algo mas que deba de saber yo sobre esto antes de hacer la compra?
1 AnswerTeléfonos Celulares y Planes8 years agoDoes my iphone still have a contract?
I purchased my iPhone 3GS from AT&T directly in September of 2009. It came with a nice little two-year contract. I am planning to sell my current iPhone in order to purchase the new iPhone 4.
Now... since I still have 1 more year to go on my contract with ATT... if I sell my current iPhone 3GS on eBay, use that money to get an upgrade phone on my current ATT account (with the extension of a new 2-year contract), will the original iphone be contract free? Will anyone be able to purchase it from ebay without having to worry about contracts?
1 AnswerCell Phones & Plans1 decade agoIs there a new Bose Aviation Headset coming soon?
I noticed that as of May, Bose dropped the price of the Bose Aviation Headset X from $995 to a current $845. Is this to make way for a new headset? Any idea anyone? I'm thinking about buying one, and I would hate to buy the current model, only to know that two weeks later a new model was released.
ranferi denova
private pilot.
4 AnswersAircraft1 decade agoCan I get a tax credit for buying a plane for my business?
I'm a small business owner, and I have customers who are up to 200 miles away from my home office. I was wondering, if I buy s small airplane, can I get some sort of tax credit for it? What are the advantages and disadvantages of doing this?
btw, I'm a regular here at Yahoo Answers, and I already hold a PPL.
2 AnswersAircraft1 decade agoCan I fly IFR on the DA-20?
My flight school recently added a Diamond DA-20 to its fleet. I have only flown it once as an intro flight about two years ago, and logged .8 hours.
I was reading about the aircraft on wikipedia, it it says "Although the DA20 is available with instrumentation and avionics suitable for flight under instrument flight rules (IFR), its plastic airframe lacks lightning protection and thus does not qualify for IFR certification."
Does that mean that I can't fly IFR on the DA-20? What about the DA-40, are they the same? (yes... I know the Da-40 is a 4 seater, I'm asking about flying IFR).
----------
2nd question: (to save some points)
My flight school will be charging $120 hobbs hours, or $110 for block rate. Is this a reasonable price? The year model of the plane is 2005.
In contrast, that same flight school charges $74 block hour, ($84 regular) for renting out a Cessna 152 (model 1974), and $99 block ($109 normal) for a Cessna 172N (1997).
Any comments? Ten points goes to the most helpful answer.
4 AnswersAircraft1 decade agoHow do I install the headlights on my Mitsubishi Eclipse?
The driver's side headlight burned out. I purchased a similar headlight already, but I was unable to install it.
My car's information: 2005 Mitsubishi Eclipse GTS Spyder (convertible). V6.
Yes, I have the owners' manual, but that isn't giving much detailed information at all. Basically, I was able to pull out the old bulb. But when I got in to install the new one, there seems to be a metal sprint and won't lock back in. The place is VERY tight and it doesn't allow me to work a lot with such a limited space. Is there a website or something with color images that shows how to lock back in that spring? ALL help will be much appreciated, 10 points for best answer.
1 AnswerMitsubishi1 decade agoHow to get a visa to Mexico?
My friend and I want to make a trip to Mexico. I'm a Mexican citizen, so I don't require any documents other than my passport to enter the country.
My friend is a citizen of Colombia. We both live in Austin, TX, which means our country of exit will be USA.
Anyhow, my Friend only has a student visa to stay here in the USA has he goes to college. Like I said, we both want to go to Mexico over the weekend. Does anyone know how hard it is for a Colombians citizen to get a visa to enter Mexico? About how much does it cost? How long it takes to get? How long does the visa last? Any helpful information would be great, thanks!!
10 points for best answer within the hour. Thanks!
2 AnswersOther - Mexico1 decade agoCan I do an ILS approach while only being a private pilot?
I hold a PPL. My friend and I are trying to get night current. I'm already am night current, but I'm just going to get more night time. Since he is in the process of getting his IFR, he'll do an ILS approach under the hood. I will act as a safety pilot.
Now my questions is, can I try an ILS approach as well? Is it log-able as an instrument approach?
If you can reference the FARs, it would be great too. Thanks!!
7 AnswersAircraft1 decade ago'05 Mitsubishi Eclipse Spyder water leak problems.?
Hi. I have an '05 Mitubishi Eclipse Spyder GTS. I've noticed that every time it rains or I wash my car (either car wash or manually), water leaks to the inside of the car exactly where the side-view mirrors are at. It leaks a large amount of water. Has this happened to anyone else? Is this a known issue with the Eclipse model that I have? Who should I take it for repair?
3 AnswersMitsubishi1 decade agoWhat's the difference between a Mitsubishi Eclipse Spyder GT and GTS?
About a month ago, I was going to purchase an '01 Mitsubishi Eclipse Spyder GT, but a week ago I managed to purchase an '05 Mitsubishi Eclipse Spyder GTS. My question, what is the main difference between the GT and GTS models? Both of them were 5-speed manual transmission. Any horse power difference between GT and GTS of the same year model? Pros and Cons of each other?
5 AnswersMitsubishi1 decade agoMy new item got stolen, can Chase debit card refund me?
Four days ago someone broke into my apartment and stole over $3000 worth of stuff. Included were a pair of Bose headphones which I had just purchased a week before for over $1,088. I filed the headphones as stolen on the police report, and I still had the serial number. My question, can a Chase Bank debit card (master card) refund me like they do with credit cards?
9 AnswersPersonal Finance1 decade agoHow do you say jukebox in spanish?
My friend's call it "rock-ola", but I KNOW that's not the answer. Anyone please?
2 AnswersMusic & Music Players1 decade agoI have a red RAZR cellphone from Sprint, but it got disconnected. Is there a way I can get a new account w/it?
I want to get the new account using my old Razr which got disconnected months ago. Actually, the phone belonged to a friend of mine, and he gave it to me after it got disconnected for not paying his bills. Will this cause a problem? What should I do??
4 AnswersCell Phones & Plans1 decade agoI have a red RAZR cellphone from Sprint, but it got disconnected now. Is there a way I can get a new account?
I want to get the new account using my old Razr which got disconnected months ago. Actually, the phone belonged to a friend of mine, and he gave it to me after it got disconnected for not paying his bills. Will this cause a problem? What should I do??
2 AnswersCell Phones & Plans1 decade agoCan I use my Sprint RAZR with a Cingular SIM pre-paid card?
2 AnswersCell Phones & Plans1 decade ago