formula calculation

Hi, I would like to mimic goal seek for the following but unsure how? Current RRP New RRP Current Selling price New Selling Price Current Margin = (RRP-VAT) - Selling Price I would like to change the current RRP (i.e £2.50) to a New RRP (£2.40) which then changes the current selling price...

I surely hope someone can shed some light on this problem. I have a worksheet that uses this formula to average letter grades: {=IFERROR(INDEX($C$52:$O$52,MATCH(SUM(SUMIF($C$52:$O$52,C5:N5,$C$53:$O$53))/COUNTA(C5:N5), $C$53:$O$53)),"")} The formula is copied down to all cells below P5 to P40...

Hello all, I have this formula in a cell that adds-up entries in various cells (10 per row), and gives me a percentile. Is there a way I could streamline it so I do nor have such a LOOOOONG formula...

Good morning, I'm trying to get a solution for my problem. I'm sure this is fairly simple, but I don't know how to resolve this combination. So, I need your help. I have a combination of 20.10.10x5.15.25/ in cell A1 The problem are: a. The result for combination before "x" should be the...

Hi all, I'm facing a performance issue concerning tables and dynamic ranges. I'm not sure I can do what I want with basic Excel instructions WITHOUT macros... Let's say that in Sheet1 I have a BIG table (eg. 10000 rows) that periodically grows in size by new inserts. In Sheet2 I need to have an...

I am hoping for some assistance. I have Windows 7 Home Premium with Microsoft Office 10, using Excel 2010 v.# 14.0.4734.1000 32-bit. I have a tab delineated text document I have imported into excel. I am trying to then format the data to be imported into another program. The following is an...

Back in 2006 Domenic posted reply below for how to rank visible cells when using excel's auto-filter. I am hoping that someone can break this down in English as to how (maybe why) it works. I just can't follow the steps inherent in this formula.:eeek: Please help interpret Here's the quote...

I have the columns "ID" and "Name". I want to generate an ID for every row but only for each different name so something like this: <table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col...

Hi I am building a timesheet and I have become a bit stuck. I have already got the timesheet to automatically calculate the number of hours once the start time and end time are entered(these cells are all in hh:mm format). The column which calculates the total time is AA4. Then I have the...

I have the following formula in cells to pick up the tab name; my probelm it shows the name of other tabs when edited. I there a way to get on the tab name of that worksheet? IF(B2<>"",MID(CELL("filename"),FIND("]",CELL("filename"))+1,30)&": "&IF(A1<>"",ROW(2:2)-1,ROW(2:2)-2),"") Thanks...

I have a EPL predictions game where players predict the final finishing positions in the league for each of the 20 teams. The scoring works as follows... 5 points – Correct Place 3 points – 1 or 2 places out -5 points – wrong by more than 5 I am trying to add a formula to work out the score...

I am a newbie and need help. I used an ODBC driver to import data to Excel. I then added two columns to the left (Column A and B) of the data with formulas to calcuate age. Now I have a couple of problems. I think the problem is with the two columns that I added but not sure. I don't see anwhere...

I am trying to autosum Column F on the row that starts with Total. Each F cell contains several If/then formulas to achieve the value that shows in F. I would like to add to those formulas so that they return the value, unless A7, for example, contains the word Total - then I would like it to...

This may be a simple questions but it has me stumped. Coumn D has a lot of data in it, my formula sums the data starting at D4, EXCEPT for the last 6 rows [=sum(D4:D20)]. I have a macro that inserts new data by INSERTING a row and pasting the new data in. However when I do this my formula 'moves...

Hello Not too sure if this is possible, but looking for help with the following formula. =IF(AND(Training_Plan_2011.12!H9,"COM 1"),(Training_Plan_2011.12!A9,"7-Mar"),"Training_Plan_2011.12!I9","") I'm working across spreadsheets and basically trying to get excel to input the value of a...

I need to make a formula that satisfied the following logic: If F7 is less that 100,000 F7 equals 250 If F7 is greater than 100,000 but less than 500,000 F7 equals 537 If F7 is greater than 500,000 F7 equals 750 I tried making a formula but im useless...

I'm trying to write a formula to let me see the date a person last attended a meeting but I'm getting stuck. say the person attending the first meeting a date is entered in to the cell the part that I'm getting stuck on is what forluma would i use if he attending the second meeting to...

I am working on a report that will highlight progression of learner either red amber, of green based on values of week number on program and percent complete. Where it gets interesting is say week is 48 should show 100 percent will be green but if lower that 90 show as red I want to be colour...

HI, I am trying to calculate the last value in an IRR casfhflow to make the total cash flow = 15% IRR I have a string of numbers, -100, -10 , 10, 10, 15, X. I am trying to find the value of X that makes the cashlow = 15% IRR Can anyone help with a formula? Thanks, Ryan

Instead of: N3*M3 N4*M4 N5*M5, ETC. I have over 200 rows so far. I want to be able to say: Rate times quantity where N column is the rate and M column is the quantity for each row that I have. I add data (rows) each day. How do I name the cells so that I can use a named cell in the...