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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top