checks

  1. B

    Multiple IF values for cell

    =IF(C9="Read Only","n/a",IF(C9="Quarter 4",SUM(D3,0))) C9 can be Read Only and Quarter 1-4, This checks for Read Only and Quarter 4, how do i get it to check for Quarter 3 2 and 1
  2. C

    Issue with If ElseIf not Working Properly

    I have a macro where I select files to open then my macro runs on each file. It checks cells within a range for the correct data I have everything working except a small part of the code. If Range("D1").Formula <> "=Latest!C5" Then ElseIf Range("D1").Formula <> "=Latest!B5" Then MsgBox "Cell...
  3. B

    Select Case To Check Date Ranges

    Hi Guys, I am using the below code to do checks for a automated holiday spreadsheet. if first checks to see if the user has enough holiday "<26" and then checks to see if they are not trying to request more that 10 days " < 10 ". the dates are declared in two cells From " B21" To "C21" what...
  4. M

    VBA checking to see if a string of text contains a certain syntax

    Hello, What I am trying to accomplish is the following, One of the columns in my spreadsheet has Item Numbers in the form of ABC-123-100X50 for the Prefix ABC and DEF-123-50 for the prefix DEF, What i want to do is have a check that will see if the Prefix is ABC then the string must contain...

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