and or formula excel 2007

  1. M

    Adding another function to existing formula with IFs and ANDs

    Hi, I am currently using the following working formula =IF(AND(ISBLANK(G59),AND(ISBLANK(B59))),"Need Concurrence or Signature",IF(ISBLANK(G59),"","Paid")) Now I'd like to add another argument, but nothing I have tried has worked. I would like to add IF(ISBLANK(E59),"Unassigned", NOT SURE HOW...
  2. S

    Need Help with Or And Statement

    I need my spreadsheet to return a true or false ("" or *) based whether one AND statement exists OR another AND statement exists. It really all hinges on whether cell M17 is blank or has a value placed in it. Here's my current formula that is not working. Any help is greatly appreciated...
  3. S

    Nesting and AND OR IF statement

    I am using Excel 2007 I need a formula for the following: IF B17 has any character (number or text) AND M2 or M3 or M4 or D17 or F17 or I17 or L17 are blank Return "A required field is still empty." Otherwise return "" In otherwords, if B17 has something in it then ALL of the other cells...

Some videos you may like

This Week's Hot Topics

Top