answer

I’m trying to query a value in a row/column and depending on the value provide an answer in another row/column. The data I’m checking against is a number sequence which needs to be queried to see if it’s between a series of more than/less than/equal to statements. Ive done these before for...

<colgroup><col span="2"></colgroup><tbody> Fruits Years apple 2018 apple 2018 orange 2018 banana 2018 peach 2019 grape 2019 apple 2019 melon 2019 2018 3 </tbody> hi i got this case, can you help me out for the formula? as u can see the answer is 3, but when i change to...

Hi I need to sum all the results from the column and understand SUMPRODUCT may be the answer. Any help would be appreciated :)

Does anyone know how to do this? Wanting to make a calculator where we input a number into a cell, say D1. IF the number falls within a particular range it gets multiplied by a particular number and the answer is displayed somewhere, say G1. If the number falls within range 6225-6725, then it...

A neighbor of mine thinks that I'm an Excel genius (I'm really just average), and asked for some help building a spreadsheet. He keeps track of new hires at his job and meets with them at 30, 60, and 90 days to review their progress on the job. As best I can understand, he wants a spreadsheet...

Is it possible to have a spreadsheet, whereby in cells B3:B22 (for example) you have "Hidden" answers, and in A1 you have a text box, you put an answer in, and press enter. If it matches, then it highlights the answer, and clears the cell for the next go. So, in B3:B22 you could have the...

Hello Wizards, I'll explain this the best I can I'm developing a calculator in which the answer in D10 needs to be divided by a different number according to its value. Example If the answer is between 0-100 it would be divided by .5 101-200 divided by .501 201-300 divided by .502 etc How...

Hi I'm trying to use the LOOKUP function featuring multiple criteria to return a value from the previous occasion where both criteria are TRUE Please have a look at the screen prints attached. On this occassion there is just 1 TeamID running through the spreadsheet. But sometimes there are...

Morning, I have a calculation that looks at the values of a range of cells in a row: {=IF(ISNUMBER(SEARCH("Yes",AG2:AJ2)),"Yes","")} This returns an answer of "Yes" if it discovers a "Yes" in any of the 4 cells and leaves it blank if it doesn't discover any. I would also like it to return...

<colgroup><col><col><col><col><col><col><col></colgroup><tbody> Telecast Date Telecast Day Day Start Time End Time Time Zone Answer 1-Aug-19 Thursday Weekday 7:00:00 12:00:00 Morning Prime Time </tbody> i need Timeband Name in answer format Weekday starting 07 to 13-PT Starting...

Hello, I have an excel file with about 30 sheets, each with the name of a nurse at my hospital. What I'd like to do is count if the field E11 in each sheet contains "NA" if a nurse has given an invalid answer to a question. If the nurse has given a valid answer the cell will have a number...

Good day currently I am using this formula,but I would like the formula to return a "0" if the answer is 0.5 or less. =IF(E8>0, (F7-(F8-(E8*55))),IF(F8=0,"",(F7-F8)))

Hi all - I have a macro that will open a bunch of files, update the links, and save them. Occasionally a link can't be updated and an alert pops up. Is there a way in the macro to answer that pop-up? I want to code "Continue" to the Alert. Any help would be most appreciated. Amy

I'm an idiot or something. I took, what I thought were pretty straight forward directions on here, but it's not working out for me. MISC S1 has a month in it. I get an error no matter what I do with the "Set ws = Sheets(MySheet)" line. I just want that "JUL" to change depending on the cell in...

Hi all, Can someone help give me a formula that would imitate the PV function of excel. For example, if I use the below formula, then I would get an answer of $10,000 =PV(5%/12,60,188.72) What I need is a formula that would give the same answer without using excel's built-in PV function...

Microsoft Excel 2007: I have the following formula in J45, which gives wrong answer as 0. =SUMIFS(D5:D33,C5:C33,">="&H40,E5:E33,"<="&H41,G5:G33,"TaxSave") D5:D33 Amount in numericals C5:C33 Start date in dd-mm-yyyy format E5:E33 End date in dd-mm-yyyy format G5:G33 Text msg...

I am looking for a formula to look in times in A1 and A2 (A1 has start time and A2 has finish time and tell me how much of that time crosses over the hours between 1800 and 0600 Example A1 = 2200 A2= 0800 answer would be 8 hours Any help appreciated

Good Morning is it possible to answer the following question without creating a data list (to reference in a countif formula) I have a range of data in column A of Worksheet 1 1 1 1 2 2 2 5 5 5 and so on The question states which number is represented 10 times. i can work out the answer...

Hi first post, so apologies if I make a mistake I need to count the following <tbody> Meter P7 2016 -2017 P7 2016 -2017 P7 2016 -2017 P8 2016 -2017 P8 2016 -2017 P9 2016 -2017 P9 2016 -2017 9761600 165 167 165 217 233 207 212 9763705 237 220 272 240 267 194 9766902 254 245 363 376...

Hello and thank you in advance for any help. I'm looking to have VLOOKUP return a hyperlink, but one which is a reference within the workbook, rather than a URL. Can't find a format for writing the hyperlink to begin with that Vlookup can then return as working. Explanation of the below...