nested if function

Someone please please help me with this formula on #5. I, for the life of me, can not figure this stuff out! I need help with the first 3 sentances of #5 and all of #7 I have attached a link to my workbook as a google doc, the format is Excel 2010 and here are the questions for the workbook I am...

Hi, I have an excel project that I need a lot of help with :( I can't seem to grasp nested IF's or VLOOKUPS. Here is the information Product pricing is A1 subtotal and shipping cost are D2 and E2 then the list of product supplies are A3 thru 17 and under worksheet named product prcing and...

In 2 col, I m having either 0 or 1. In 3rd column i want to do the check (permutations & combinations). It is like: 0 0 A 0 1 B 1 0 C 1 1 D How to do it? Also, how to count nos. of A, B, C & D generated? Thanx in adv

I am trying to do a formula collected from Cell A1 (% of target obtained) with the following below information eg: 5 arguments: IF <90% = -25% from A1 IF between 90% & 99.99% = "no bonus" IF between 100% & 109.99% = 10% of A1 IF between 110% & 121.99% = 15% of A1 IF = > 122% = 20% of A1...

I can't get it right - I am not sure what I am doing wrong. If anyone could guide me to the right path - I will be very thankful. Here is the problem that I am working on A. The first test should test if the shipping option in cell b15 is blank, and if so, then cell c17 should be blank. B...

Hi all, Sorry to bother you but I'm relatively new to Excel and I'm ripping my hair out trying to work out one of these bloody nested if function thingies. Here's the drama; in column C I have several different entries, two of which are NQ and US. What I need to do is if in column C it says...

Not an expert so I need allot of help. In a production schedule I have various models to make with X number of units per model in a day. Using VLOOKUP I have a time value (production time) column for each model multiplied by its number of units, so I know the time it takes to produce each...

Hi Folks, I'm having a problem with a formula that has a series of "Nested IF" functions in it. Everything works fine, UNTIL I add the LAST "IF" function, then Excel 2003 returns, "The formula you typed contains an error" and highlights the second "AND" in the formula. Here's the formula in...