equals

<tbody> POSITION POSITION TOTAL HOURS AMC AMC 8 </tbody> IF POSITION AMC EQUALS 4 HOURS HOW DO I GET EXCEL TO DO THIS FOR ME?

hi, I'm looking for a formula to display a range of cells if condition is met. For example IF A1 equals to "test" then display range F1:G4 in range B1:D5. Any ideas? Thank you

hi guys, I'm having a little brain freeze here I would like sum values in cross table xy based on sum of x and y. <tbody> 1 2 3 4 1 0.10 0.12 0.25 0.30 2 0.05 0.10 0.32 0.40 3 0.14 0.13 0.10 0.15 4 0.18 0.11 0.16 0.21 </tbody> For example: sum values if Column + Row >7.5. We...

Which is faster? I have two workbooks. One has all the personnel information and the other has equipment information. They team up to create picking sheets for the warehouse. Each provides information to the other one via vlookups. I was wondering if instead of doing a vlookup I could simply...

Is there a way of combining all of the statements below into one formula? IF A2 EQUALS "RANDOM" AND F2 IS LESS THAN 126, THEN "NORMAL" IF A2 EQUALS "RANDOM" AND F2 IS GREATER THAN 125 AND LESS THAN 200, THEN "PREDIABETES" IF A2 EQUALS "RANDOM" AND F2 IS GREATER THAN 199, THEN "DIABETES" IF A2...

Hi all, this is probably easy for you guys Using Excel for Mac I have a spreadsheet, Columns A through E, many rows Column E is called due date and has a date in it Cell H1 is equals now command If H1 is 1 or 2 days before the due date, I want that row from A to E to be highlighted yellow If H1...

Hi I am looking for a formula that can vlookup based on multiple criteria. I need a formula for F4 (on spreadsheet 1) that will look up the value of column F (on spreadsheet 2) if column E (on spreadsheet 2) equals "Claro" and Column A equals the site number in A4 (on spreadsheet 1) and column D...

I can't quite nail this one down with VBA. What I'm trying to accomplish is: For a collection of rows (2:205), if the cell value in column H equals "Y" - copy and paste the values of that entire row. If the value of column H equals "N" or is blank - then do nothing to the row. Any push in the...

I want to format cells as different colours based on lists of strings. For example: Format cell in MyRange as red if value equals String1 or String2 or String3 Format cell in MyRange as blue if value equals String3 or String4 or String5 Format cell in MyRange as green if value equals...

how to get the second value if the first value is equals to zero across multiple sheets?

Hi I have the following problem. I am trying to automate a time-sheet but I am having a problem converting .30hrs to 0.50hrs. For example: C4 I have the start time 08.00 D4 I have the finish time 08.30 E4 I have D4-C4 which equals 0.30 C4 I have the start time 08.00 D4 I have the finish...

I have beat my head against the wall with this one. I really hope someone can help here. To Completely summarize what I am trying to do.... { If it is Peter's pay-week, N4 equals Y1 If it is Casey's pay-week, N4 equals Y1 + Y2 } -----------------------------------------------------------------...

I can't describe my problem any better: if (sheet1!A1 == sheet2!A1 && sheet1!A2 == sheet2!A2) { sheet2!A10=sheet1!A3; } If a cell equals to another cell on another sheet, then a given cell should have the value of a cell from another sheet.

Hi Guys could someone please help with this formula, it states there's too many arguments =SUMPRODUCT(--(SIP!AE:AE=WOD!$F$13),--(ISNUMBER(SEARCH("*Newly",SIP!K:K),SIP!U:U) basically i want the formula to Sum Values in column U, if column AE equals the value of cell F13 and if the Column in...

Hello, If my sum cell equals 25.13, and I want that cell to round up to 26.00, what formula would I use?

I'm not getting any results... or FALSE... no matter how I write this. Can anyone help? If Column A:A equals $B$1, If Column D:D contains "Battery", then give me the date from column S:S. Thank you, Sharon excel 2010

if Cell A1 equals 53 months, I want B1 to equal 4 years 5 months.

Hello, I am trying to expand on the following formula: =IF(B1="","","Hi") Verbally it reads, "If B1 equals blank, put blank, other wise put HI." What I'am trying to do is add another criteria for the blank portion such as: "If B1 equals blank AND John, put blank, otherwise put hi." I don't...

Hello, I'm needing help wit the below: I need column F to highlight if column C equals 30. I've tried =IF(C:C,30) and it isn't working.

I need a macro that checks column G for either a 0 or 1 and then deletes the row if the cell equals 0. I have a huge array of 1200 cells to run this through.