help excel formula please

Hi All, I can't get my head around this. <tbody> A-B-C Store %Conversion A 9,2% B 7,50% C 9,0 </tbody> So I have my A-B-C store and the expectation are different for all of them in terms of condition. Right now, I'm doing manually, but I'd like it to be automated. So when I enter the...

Hi All, I've been playing about with try to work out a way of finding when the next promotion is due on this sheet, so far all I've seemed to do is make things more complex on the sheet, is there a easy way of find out when someone due there next promotion. I've included the sheet below...

I need some serious help I need to create a date calculator but I need to exclude certain dates only if the end date falls on that date. For example, 1/2/15 and add 15 days... but here is where I am stuck... Only if the date falls on a weekend or federal holiday I need to skip to the next...

I am not Excel Savvy at all and have spent the better part of the weekend trying to learn/figure this out but have hit a wall. Work has tasked me with creating a spreadsheet that holds the records of 1000 or so employees and their regular tests. To achieve this I have created a manual entry...

Hi! I have a formula question. I am in Excel and am trying to pull data from two different rows to determine what to input for another row. For example, Column B Row 6, I have a $ Total. Column B row 8 I have a number that tells me how many Exemptions this "person" uses. This number...

Hey there, I am trying to understand how to create a formula that would pull what I currently have in the Input Cells automatically when I update the other spreadsheets. The cells will change as I update, but I still want it to give me the sum for what I am asking for. For instance, on the...

Please I really need help! I am definitely a beginning excel user, and after using google and looking through this forum I am still unable to figure this out. Answers will be much appreciated! Basically I have data that specifies how much of each item (codes) are used per phase. For example...

I am trying to write a function with some built in logic to process a list of data. The list of data will be sorted from smallest to largest by FREQ/Vis column. This is done with a macro. What I think I need is an "If" function with an offset embedded into it. Below is the list of data that I am...

I'd like to know what kind of formula/what is the formula to have Excel figure something like this out: Say A=7 B=12 C=30 D=Scaling(1-100) Like a unit's level And it will make Q=((A*B*C)+(C*D(also D-1, etc)) like an Arithmetic progression. Where D is Q/((A*B*C)+(C*D(also D-1, etc)) So for the...

I am new to using excel and was hoping someone would be able to help. I am wondering if there is a way to scan a barcode into excel and the have excel recognise it and count how many times the same barcode had been scanned. So basically have 3 columns Barcode, Product name and Quantity.

Hello Guru's I am in need of a Excel GURU that understands lego ...yep those little tiny bricks. If you also understand API that is a plus as thats the next step I need. I have found the people on this site are STELLAR!! Who is up for it>

I am having a lot of trouble getting the vlookup formula to work for me. i've trimmed the date, made sure all the data was identical and still cannot get it to work. I have no idea what else to do. I've literally spent over an hour trying to get this simple formula to work and cannot figure it...

Okay, so I have this spreadsheet set up, I only want it to count if all four of the cells read true. so I have this set up. This continues on through G202. Here is my problem, whenever only G7,8,9, and 10 are true it is giving me a total of 2 instead of just 1. It does the same with...

I have Several Countifs and want to make it into one saying if this area was assigned by one of these people count the job, I have tried many different ways and can not seem to make it work. unless I have it search for each assigning Person one by one. Is there a way to make this Formula much...

Hey everyone! Thanks for any input on this issue I'm having. I have a workbook that has assignments that get done throughout the month. I need the date to autopopulate based on criteria so I am using the IF() and NOW() functions. The date populates fine, except if I save and close and then...

I have a huge list of locations that are written in a variety of formats (city/country, region/country, city/state/country, etc.). I want to just pull the country out of the cell and disregard the other information. I have a master list of every country in a separate sheet and was wondering if...

Hello, New here, but pretty certain i searched through all forums for an answer to my questions before posting this. I've been stuck on this for a couple of days now. I have three columns in a table I want to use for this formula. Build Status (Column A), Data Submit (Column B) and Ship Date...

<tbody> Here is a sequence I have In my excel, How do I delete all the long digit numbers and then organize all of the numbers and move them to the top in order, in a list form for printing. I also have a bunch of random words in the list such as Page 5 of 555 which I would like to delete. all...