if then formula

https://drive.google.com/file/d/1ly_TVkX804dgmNfMscyBRXCAs3vtx-jp/view?usp=sharing I have built a sheet that helps me manage my inventory. I have a BIN REPORT and REC INPUT tab where i update information which then feeds to my CONSOLIDATION tab which helps me minimize warehouse space. I even...

Please help identify the write formula to return values in column D. The idea is that if people share the same number in column B and the same color in column C, column D should be "true". If they have the same number in column B but different colors in column C, the value in column D should...

hi, I'm trying to create a line in my macro to show a msg box if cells in a give range begin with a certain text. For example, if any cell in column O begins with "ES", msg box "Spain Trades"(no action if not). Thanks!

Hi All, I am trying to do the following: in my workbook H34 (It is actually H,I,J as those three fields are merged) is H12 (H,I,J) * 100 I need to write a formula so that if H34 is less thqn $2500 it will multiply the number of locations (H12 x $100), but if H34 is $2500 or more it will enter...

I have one column of names that is fixed, and a list of names that I get on a weekly basis. For example: Varying Names Fixed Names Brandon Steve Lucas Drew Andrew Jordan Jake...

Hello all, I have an advanced "if then" question, thank you in advanced for any help.. I have 45,000 accounts, some duplicates that had 1 piece of equipment per account... I already concatenated the information to give me 20,000 UNIQUE accounts with a cell of multiple pieces of equipment...

I would like F3 to equal E3-D3, if there is a number OR formula in E3. If there isn't anything in E3, then it would look to see if there is anything in D3. If there is, then D3-C3. If not, then see if there is anything in C3. If there is, then C3-B3. If not, then = B2. Is that possible? Thank...

First time I have been in a forum and not very experienced with excel, sorry in advance of any errors I make. Goggle has got me this far but I am stuck. I am trying to create a stock trading journal that has some calculations in it. I am sure it's no work of art but again, not even basic...

I am using Excel 2010. I have already created a drop-down box with selections of T-shirt sizes ranging from YXS to XXXL. Original drop-down cell in my form is B23. Named range for this drop-down is TSHIRTS. In my order form, T-shirts are $10 for sizes YXS to AL. However, if someone selects XL...

Hi - I have a large list of times (about 500,000 rows) I need to assign a certain word (1st, 2nd, 3rd shift) to certain times frames within this long list. All times between 6AM-3PM, I need to automatically assign the word '1st Shift, to come up in the row next to it. As follows, 3PM-9PM ...

So I want to do the following. In columns b1, c1, d1, e1, there will either be FALSE or a label. For this example, lets say it will be either FALSE or the label MATERIAL. The sheet will look as follows B1 C1 D1 E1 FALSE FALSE MATERIAL FALSE So for A1 I want a...

I have a worksheet with departments, categories and times. The times are currently in minute, hour, day and week format. I am looking for a formula that says if the time in column e is 15m then column f shows .25 or if the time in column e is 1h then column f is 1 or if time in column e is...

Dear All, I am trying to create a quotation where I multiply my costs to different values depending on where the merchandise comes from, using Excel 2010. In the first column I would put my cost price. In the second column I would put the country of provenance. I.E. A for America, E for...

Here's my problem: I'm looking for a formula to change a weekday in the previous month - the day that is 30 days from a day in this month - to a Monday of the following week, if it's a weekday oother than a Monday. For example, if 30 days from the current month (June) is May 24, 2012...