if statement and and function

  1. B

    If and function with three conditions

    Hi Everyone, I'm trying to add an additional condition that doesn't seem to work and I can't figure out why. The new condition is looking at another column for the word "yes". My current formula is following: =IF(AND(COUNTIF(_AG22[Loan ID],[@[Loan ID]]),_AG22[Open...
  2. K

    if statement - updating cells based on condition

    hello have a range of cells that I would like to be updated if the if and statement is true. ex. if cell P23 is True and if cell ranges M25 is not blank, I want the code to clear the data in the column O25 and update the text to Working. I Would like this code to run through all cells within...
  3. T

    And with If statement not working

    Below I have a formula using the AND function with my IF statement (Y35), but notice it is not performing correctly. I should of returned A35 and not ??. Trying to understand why this is not functioning correctly. Hopefully this issue will resolve my vlookup issue where, for...
    • topswim
    • Thread
    • if statement and and function vlookup and array
    • Replies: 22
    • Forum: Excel Questions

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
Back
Top