answer

I have been trying to get this to work and to no avail.... =IFERROR(VLOOKUP(H5,'C:\folder*\Folder*\Folder*\Folder*\[Auctions Offered Template.xlsx]Auction Offered'!$D$3:$G$33,2,FALSE),"") The Folder* is just a placeholder for my file path. I get a result 0. However that is not the answer...

Hi guys, I have a form I created for our department that has dependent drop down lists that I have cobbled together that is barely held together with spit and duct tape :) But I am having some issues creating another set of dependent drop down lists. I have three section with dependent lists...

It's been a while since I las posted anything. I has trying something in excel but I am not sure if it's possible. Here's the problem: A1 is a blank cell. No formulas or anything. B1 let's say has a value of 1.33 In C1, I would like to create a formula that will if B1 is not blank, the make...

Hi, I’m trying to figure out for a week trying to research what could be the formula for below for instance A1 = 87.5 A2 = -4.0 the answer should be 91.5 (87.5 + 4= 91.5) however if A3 = 91.5 A4 = 5.0 the answer should be 86.5 (91.5 - 5.0 = 86.5) The formula should be in one formula, so...

I am trying to write an IF function based on 3 conditions. It will test the following (A3+B3)*.1 = answer. If the answer is less than 150 then display 150. If the answer is greater than 400 then display 400. If the answer is between 150 and 400 then display answer. I have tried a nested IF...

Hi all, i have searched the web for a formula that would allow me too multiply the first 10,000 of a number in a cell by 0.45 and the remainder of the number by 0.25 then ideally putting it into 2 separate cells ( one for the 0.45 answer and the other for the 0.25 answer . Although its not a...

Hello all I am looking for a formula that will multiple a date as months U6 = 12 V6 = 12/01/2019 12 months x 12/01/2019 Answer would be 12/01/2020 U6 = 6 V6 = 12/01/2019 6 months x 12/01/2019 Answer would be 12/07/2019

Apologies if this has been posted before or it is a basic request. I have looked into VLOOKUP and index but nothing works This is my table. I'm looking to type text into B1 to look for matches in C column and type into B2 to look for results from D6:G10. Then display the result in B3 whether...

Hey I have a table with 3 columns COLOR NUMBER1 NUMBER2 An example can look like this: <tbody> Color Number 1 Number 2 Green 1 10 Green 1 10 Red 2 20 Green 2 20 Yellow 3 30 Red 3 30 Green 4 10 </tbody> Now i want to answer this question. What is the...

I am attempting to get a combined total for a range of cells that contain a number and letter. Example 8v+3v with it giving the answer of 8v. Any ideas?

Hello Excel superior beings, I bow to your wisdom and knowledge. I know this must be possible but I cannot think of how to do it and have used this forum in the past to find information but cannot think of how to even look for the answer. I have a list of groups with group ids and members of...

I am having trouble adding one line to an IF function. I have learned that I can use up to 7 IF functions in a formula. My goal here is to get the difference between two dates and depending on the answer, the cell gives the green/amber/red answer. I have figured out my main goal, but got a...

Hi. I have a code that allows the end user to delete selected rows from a protected table. The problem is, as it is now my macro can delete pretty much anything that gets selected and I'm worried that something else outside the table will eventually get deleted by accident, even though I've...

Hi can you say what I did wrong here I want to say if the value in bi is greater than 1384.116 then take bi and minus it from 1384.116 then that result must be multiplied by 70% of the value in c1 then multiply that value by 25% thanks tks Abidh (IFB1>1384.116, then(b1-1384.116)-(.7*c1)*.25)

I am setting up a department file that requires macros to be enabled. I have the code working to the point of opening the save as dialog box, but I am unsure as to how I can force the file type to default to macro enabled. Hopefully someone can help this beginner figure this out. 'This...

Hi All, I need a formula to remove commas from a cell... Sample Data 123, 456, 567,,,,,, required answer 123, 456, 567 990,256,, reqiured answer 990,256 12567, 308211, required answer 12567, 308211 I want all commas to be removed which are at the end of the cell value Any...

Hello...I am a middle school math teacher who is trying to create a SEARCH formula that will require more than a one-word answer, and I also need the formula to return a '2' for true and a '0' for false. For example, the answer to a particular word problem is 'Sara', and students have to justify...

I have always had good luck using this site as a resource and figuring things out on my own, and have more than once gotten help from everyone here when I couldn't find the answer. I come to you again in the hopes someone can help. My problem is simple but I cant wrap my head around the answer...

Hey everybody. Error 13 (type mismatch) occurs when I try to run this macro. Nevertheless, I can't find out which data types are incompatible. Could you help me to find it out, please? Here is the code. Public Sub Macro1() Dim m, n, p As Double Dim x1, x2, xmin, z As Double m =...

Custom Formatting is driven by the format code (E.G. #,##0, etc). When I look in the format dialog box I don't see a code for "General" - it just says general. I'm curious, what would be the custom code for General - does anyone know? I tried to google it but couldn't find anything specific to...