logic if

  1. O

    If statement false value referencing same cell as formula cell

    Checking a outside model that I received and the if statement false value is referencing the cell in which the formula is being written. If I try to recreate this, I obviously get zero, which is not the value the cell in the model is returning when the logic is false. My question is, how is an...
  2. J

    multiple logics

    I have a software called REVU where I can collect measurements off of a plan and export them into an excel sheets. I also have a previous excel sheet where I enter all my data. I want to be able to take the REVU file, upload it into my existing file and have my existing file search for certain...
  3. A

    How can I fill certain cells with color depending on what info is inside?

    I need to look up a range (BE4:BE2383) and if the cells read "Pass" I want it Green if the cells read "Fail" I want it Red. How can I automate this?
  4. A

    OR Criteria for a List of Contracts

    I am looking to populate column C with a "Yes" or "No" value depending on if it meets the criteria in column B for contracts in column A. Each contract can have unlimited values in column B (actually 100 max), but each value is entered onto a new line and the contract is duplicated. Column B has...
  5. T

    Hello Mr Excel world, help needed with IF, AND & ISNA combo

    Hi fellow Excel lovers, I need help to fix this seemingly simple formula but so far it's eluding me; =IF(AND (ISNA(R2),ISNA(U2),ISNA(X2)),"Needs Subbing", "Subbed") I've tried it with =TRUE after each reference and at the end of them and rearranging the brackets structure. I have a feeling...

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