1. G

    Split value in half and add

    <tbody> A 500 B 750 C 750 </tbody> How can I split A in half and add the half (250) to B & C to equal 1000 or it can not be done? Thanks in advance GT
  2. C

    IF Statement Formula

    Hi, I'm trying to figure out a formula that has a number of parts. Let's say that we have columns A, B and C. Column A will contain either a date, or be a blank cell. B will contain "Accepted", or a blank cell. I want Column C to return either "Open", "Approved", or be blank, depending on...
  3. K

    Conditional formatting based on another value

    I have two number columns A and B. I want to highlight column A with either a GREEN fill or RED fill. If the value of A is greater than B*0.95 AND A is less than B*1.1 fill it GREEN. If the value of A is greater than or equal to B*1.1 OR A is less than or equal to B*0.95 fill it RED. Been...
  4. J

    Not Equal to, if statement

    This is super easy for the experts but I can't figure this out with 2 arguments If cell D9 does not equal "WI" or "IA" then return a 1 - otherwise display 0
  5. C

    IF or IF(And) formula for 3 logical tests - Excel 2016

    I know this is a fairly easy question but as my Excel is very rusty and I am trying to learn the features of Excel 2016 this has me stumped. The question I have been given is - Enter a function to calculate the award give - my chart has from 4 years of service to 27 years. If the employee has...
  6. S

    cell equal only filtered cell

    Hello: In column A, I have 1,299 unique part numbers. The end user is going to choose one through a filter. I need cell B1 to equal that filtered number. I need this because I am doing an Indirect formula that needs just the chosen (filtered) part number, but because the filtered number is...
  7. H

    Either of 4 cells equals a value then get the desired result

    How to formulate: IF EITHER of B2 or D2 or F2 or G2 is EQUAL TO 1 THEN I2=100 ELSE “” I am using Excel 2007. Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 33px"><col style="WIDTH: 33px"><col style="WIDTH: 33px"><col style="WIDTH: 33px"><col style="WIDTH...
  8. C

    Return value adjacent based on match

    Hi all, I believe I've done something similar to my current problem but I can't quite figure this one out. Would appreciate any advice! I'm trying to match 2 values in different columns and then return the adjacent value from a third column. Hopefully this demonstrates it clearly. <tbody>...
  9. T

    Applying two conditions in formula

    Hello, Trying the following formula and I keep getting an error: =IF((AND(E4="FT",(U4<=DATE(2010,10,10)),IF(V4>=160,L7,IF(P4>=12,L6)))) I'm trying to meet the following condition: If the cell in E4 is FT AND the date in U4 is less than 10/10/2010, evaluate the following: if cell V4 is greater...
  10. D

    How to use Macros to Filter less than or equal to Cell Values

    Hello, I want this Macro to filter off less than or equal to, not just equal to. Also, if one of the cells is blank (B2 or C2) I would like it to show 'all' for that selection, rather than 'none.' Can anybody help me? Private Sub Worksheet_Change(ByVal Target As Range) Set Target =...
  11. B

    Conditional Format Brain Fart

    Hello all, I am struggling with what I think should be pretty simple. I checked around for examples and still stumble. Please help. Column C has a number Column W has a number I need the cell in column W to highlight if it does not equal column C Both of these columns should be equal...
  12. D

    Help with making two DATE cells equal

    https://1drv.ms/x/s!AvjBsEPEq12ngUhA_FQ2c4n1ukg6?e=cF7u0s Need help with making two date cells equal. First cell is the date Second cell is a formula How do I make the formula to be equal to the date such that I could do a vlookup off of it
  13. N

    Excel Formula to give unique countif

    Hi, I'm trying to write a formula that says count unique values in the range of b3:B4 where bn3:bn4 does not equal no change. Any idea how to write this? Thanks, Mark
  14. H

    Merge two ranges together and wrap them into each other

    Hi all, I want to merge two ranges together. The first range is equal to Sheets("1").Range("B1:AA100") the second range is equal to Sheets("2").Range("B1:AA100") I am familiar with the UNION-function, but I want to merge them differently. Basically, I want to merge them column for column...
  15. K

    Nested formulas

    I am trying to create a formula that includes the following =IF(T2=0,IF(ISNUMBER(SEARCH("Redemption",E2)),"Redemption",IF(ISNUMBER(SEARCH("Subscription",E2)),"Subscription",))) HOWEVER, if T2 does not equal 0, it will equal "Exchange" but i need it to also look at cell P2, and if p2 contains...
  16. T

    setting cell to equal cell below

    Hi all, I have blank rows in a table that I want to have equal the row below. The idea is that, while cells immediately below might also be blank, we will eventually hit a row that isn't blank and the formerly blank cells would take those values. I used the macro recorder to get a sense of how...
  17. H

    Time greater than

    Im trying to writer a code to pull all names that have a start time of 11 or greater cell B2 has the following code =IFERROR(INDEX('Bid Results'!$X$6:$X$253,SMALL(IF('Bid Results'!$Z$6:$Z$253=>TIME(11,0,0),ROW('Bid Results'!$Z$6:$Z$253)-ROW('Bid Results'!$Z$6)+1),ROWS('Bid Results'!$Z$6:'Bid...
  18. V

    VBA/Formula for comparing three or four tables

    Hi, Thanks in advance, i have three columns and want to compare them, conditions are 1- If Coloumn 1 & Coloumn 2 are equal - Delete entire row 2- If Coloumn 2 & Coloumn 3 are equal - Delete entire row 3- If Coloumn 1 & Coloumn 3 are equal - Delete entire row please provide any VBA or code...
  19. P

    Clear duplicates between two columns

    Good Days, Please advise a vba code to process the duplicates values clean task, If word/text in Cell A1 is equal to Cell B2 ,then Cell B2.clearcontents ...... If word/text in Cell A65536 is equal to Cell B65536, then Cell B65536.clearcontents Else, no change Thank you very much!
  20. F

    last used row in column C equals last used row in column E

    Hello everyone, I could use some help in finding last used rows. If C1 is >0, I need the last used row in column C to equal last used row in column E. thanks

Some videos you may like

This Week's Hot Topics