formula help

Can someone help me with the formula the following please with the SUM Logic function; I am trying to put prices in - so if they select (for example) apple, banana or orange from a drop down list, the price will be $1, but if they select anything else, the price will be $1.15 So, is there an...

I have a major problem. I need a formula to come up with the combinations of balloons for my company. I have 5267 Yellow Balloons I have 5590 Pink Balloons I have 5127 Green Balloons I want them in 8 packs consisting of 3 of one color/3 of a second color/and 2 of the third. I have to...

I appreciate any help in advanced. I have promised my boss a Excel Spreadsheet calculating accrued interest to date on judgments we were awarded by first thing in the morning. Now at 3:00am I am ready to give up! Here are the columns for my spreadsheet related to my question for with an...

i have an excel grid with 3 tabs. Its a travel doc: Staff, Air, hotel. My associate put formulas in the first tab in order to tie all 3 tabs so I wouldn't have to enter people's info all 3 times. But as soon as i go to type in their info, it loses the formula. How do i type over a formula and...

Excel 2002 I am trying to reference a range of cells using a variable and then put the sum of that range in another cell. Below is my code: Dim Nett As Range Dim MRange As Range Dim MFormula As String Set Nett = Cells.Find(what:="nett.", After:=ActiveCell...

I need a datedif formula to look at the months and days between two dates and display only the months. However, i need the result (number of months) to be rounded up if the days are 15 or more and rounded down if 14 or less. right now i'm using this formula, but i'm not sure how or where to...

Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I came up with this one off the cuff and wondered if there was a different way. Here are the pertinent details. <o:p></o:p> I have unsorted data. Column E-I are performing the same lookup using a...

Hi! I have a query and am hoping one of you geniuses can help! I don't even know if it can be done but thought it would be worth asking... So, I have columns with titles at the top, and with numbers in the below cells. What I would like is a formula for a column seperate to these that...

I am making a product information spreadsheet for a business I am starting. I haven't worked with excel for a couple years so I feel that I have forgotten everything! My formulas are simple. I will give you one as an example, it starts at H2 and continues down. Down the column it appears like...

I need some help with constructing a formula. This is what I have: =IF((AND(G22="Strong Positive",I22="Positive")),"Moved Up",(IF((AND(G22="Strong Positive",I22="New")),"New Report"),(IF((AND(G22="Positive",I22="Promising")),"Moved Up",(IF((AND(G22="Promising",I22="Caution")),"Moved...

I'm needing a formula that will determine the number of days that fall in a specific month based on a date range. For example, if I have a date range of 10/15/2009 to 01/13/2009, I need the formula to determine the number of days in each month within the range (October has 15 days in the date...

Good morning everyone, Technical logic: I need a formula that can compare 20 values in cells horizontally and return the value that is the lowest. Business Logic: I have a list of 250+ items listed vertically, one item per row. In the row horizontally, I have a column for each price...

I am at a loss for a formula. Here is a mock up of my worksheet Key: PA= Previous Authorized ATP=Amount This Period P=Pending Code____CO#______Authorized______Amount_______Completed ___________________Amount_____This Period____ Previous Period...

Hi everyone. Can anybody tell me what a + sign after the = indicates? I've seen it several times before. Can't think of an example with it, but it's followed by sometimes a function argument or a sheet name. Not sure if this is some type of add-in that lets you write formulas like this or if...

Hey all, Is there a way to change the number format of a cell using an if statement. For example, if I am creating a drop-down menu that includes two metrics in two different number formats, is there a way to toggle between the number formats within the same cell depending on the category I...

Hi, My name is Chana and I am new to the site and excel so I hope that I am posting correctly. Here is my problem, I am trying to create a formula that will return a value (the name of a summer abroad program) if there is a number in the coloum of the record indicating it. Here is the...

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message --> I have a question concerning the COUNTIF function. 1)I want to create something below, in cell C2, which basically looks at the range C3:C5 and assigns a value. I have 1 rule which says that...

Hi All, I need a lot of help. I've looked all over the Internet for a template for what I am looking for, but I can't find anything. I've been close but not really. Let me explain. I am looking for an amortization formula sheet for a boat loan that I have. That is easy enough, and I found...

My client gave me a spreadsheet with 1500 records. She wants this sorted on the column in which they entered birthdates in this format: 3/14/98. This is to be used for a birthday marketing promotion. I need the sort to be ascending by the month. I can't figure out how to do this. It will only...

Hi I am using =mid to pull data into a table from a worksheet, the data that is pulled across should fall between certain ranges and i was wondering if there was a way to either make the test bold or add a * if it fell out of range. I tried conditional formating but it wouldnt work as the cell...