if

  1. L

    If both cells contain Current return yes, if both cells contain expired return expired AND if either cell contains due soon return due soon

    So I want C2 for example return one of four things depending on what is in D2 and E2. If both D2 and E2 contain "Current" then I want C2 to say yes. if either D2 or E2 contain "Due soon" I need C2 to say "Due soon" If either D2 or E2 say Expired then I need C2 to say expired If both D2and E2...
  2. B

    IF Function

    I have a if formula based on 2 cells: So.. IF D15 = YES and D17 = BLANK Then return "C2" IF D4 = YES and D18 = BLANK then return "C2" If Both D15 and D4 = YES and both D17 and D17 = blank then return "C2"
  3. Johnny Thunder

    Repeat cell reference until blank cell is reached then skip one cell down and use new cell reference. Using formula not VBL

    Repeat cell reference until blank cell is reached then skip one cell down and use new cell reference. Using formula not VBA Hello, I have a list that looks like this. Column A Column B (Formula) (Names) a2_______ John a3...

Some videos you may like

This Week's Hot Topics

Top