answer

In A15:B22, create a Data Table that calculates the estimated wage cost for wage rates from $24 an hour to $36 an hour in increments of $2 an hour.

Hello, I have registered in this forum to ask a specific question about something that I was told it's possible and you can help me to find out how to do it. I am doing an experiement in which I ask participants to listen to 40 short phrases in German (e.g., Die Haeuser sind sehr schoen) and...

Hi, I need a formula that can look down entirety of Column B and identify all the blank cells that have a corresponding Ref number in column A. The answer I would be looking for is in column D. Apologies for not attaching any files (company restriction prevents me form doing so). If you can...

Column A, cells A1, A2 etc have values in it. i.e. 525000 675000 etc. In cell B1, B2 etc I need to know how to get 7% of the first 100,000 and 2.5% of the remaining amount I.E 525,000, 7% of 100,000 plus 2.5% of 425,000 675,000, 7% of the first 100,000 plus 2.5% of 575,000 I can do it in two...

Hi, Forum newbie here, this site has helped me many times as I've always found that my query has been asked and answered before but not this time hence my first time post. So hello! and I hope someone can help on a puzzle that is beyond my Excel knowledge, hopefully I can explain it correctly...

Hi, I am trying to do an AVERAGEIFS formula but the provided answer is not correct. Current formula I have is =AVERAGEIFS(D:D, B:B, ">="&A2, C:C, "<="&A2) I have a long list of sequential dates in Column A, column B is the date a device was sent (or today if not sent), column C the date it was...

Hi all I have a raw data table and using sum and countifs to calculate answers. The 2 following formula should in theory return the same answer however the first formula gives the correct answer, but the second formula using not equal to (<>) for 'point won by' is giving the wrong answer...

Anyone know's any vba code that can automatically select answer from which an excel workbook prompts? Thank you xx

Hello, I am fairly novice to using excel, and have searched for my answer but am running low on time to find an answer, so figured I would just post to see if I can get a speedier answer. Below is an explanation of what I am trying to do. I have two tabs in a workbook with some of the same...

Hi I have in cell A1=1/1/2019 and I want to add 1 year to that date. So I did this B1 = A1+date(1,0,0) but I got wrong answer <tbody> 01/01/2019 02/12/2019 </tbody> Any idea why? I thought I should get 1/1/2020. Thank you very much.

Hi, I have a spreadsheet in which I want to find out which sport has accumulated the most playing time (example below). The answer is of course cricket, but I am having trouble with what formula I need to enter into cell J2 to provide this answer, if anyone can help at all please? I have...

Afternoon, When i open my worksheet i see a msgbox asking if the userform should be opened. Clicking on Yes should only open the form if NameForDateEntryBox.Text has a value in it. Below is my code attemp but returns variable not defined thus i dont see this msgbox question Private Sub...

Hi I have the following formula in A1 =VLOOKUP(Sheet1!$F$1,Sheet1!$B$2:$C$45,2,FALSE) I want to add to the formula to check if the answer I get is the same as in E2,F2 If the answer of A1 is the same I need it to automatically change until the value is not the same as in E2,F2 Please help...

<colgroup><col><col></colgroup><tbody> Agaram 0 55712 63218 64023 65680 77505 87426 Agrahara Dasarahalli 0 33781 41899 43793 47209 52903 55021 77701 78606 86772 88212 88880 Anjanapura 0 39902 42271 44409 44411 53203...

I have been working on this formula for a couple of days. I don't think countifs can do it and after searching this forum I found this: =SUMPRODUCT(I:N<>0)*(E:E=Q3)*(F:F=55). The prodblem is that it returns 0 when the correct answer should 5. What am I doing wrong? Thanks for the help. Rufus

Hi, What formula would I use for the following. I have 4 or 5 percentages which I need to average. If any of these 4 or 5 values are 0% then the average would need to be zero. For example if I have 100% 0% 75% 100% - I need the average top show as 0% and not 68.75% Can anyone please help, I...

With this formula, why can’t I use the cell example (F7), instead of (65%), when F7 = 10% is where it is? It gives me the correct answer written this way. =ROUND((A2+10%*A2)/65%,2) Thanks in advance.

Hi! This is NOT an compound interest question. I need to create a compound formula or table to reach a desired answer. EXAMPLE: So if I need to decrease 50 by 20%, 3 times (variable) ------------------------ 1) 50 x .8 = 40 2) 40 x .8 = 32 3) 32 x .8 = 25.6 ------------------------ Answer...

I created a UDF that calculates how many minutes it takes to complete a certain task. (ex: =MinutesToComplete(1,0.18,10,50,20) ) Is there a way to extract each argument/parameter? (ex: =RightParameter() ) and the answer would be 20

I need to find the sum of 2 numbers and those numbers could either be plus or minus. How would a formula be written for that? Not sure if I'm asking the question well, so I'm after this: Example: A1 = .0695 A2 = -.0010 Answer = .0685 A1= -.0695 A2 = -.0010 Answer = -.0750 So, A1 and A2 can...