and/or

  1. C

    Converting algorithm to formula ( embedded IF AND )

    Morning, I have the following algorithm: <TBODY> N</SPAN> Y</SPAN> Y</SPAN> N</SPAN> Y</SPAN> Y</SPAN> Y</SPAN> </TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP> The part I have bolded repeats infinitely afterwards. I need to convert this into an excel formula. Where a 'Y'...
  2. S

    Help with And and lookup formula

    :confused::confused: I have 3 columns of data. My criteria is this; if there is a number in column A that is within +/-10 of a value in cell in the same column A AND if there is a number in column B that is within +/-10 of a value in cell in the same column B AND if there is a number in...
  3. N

    Access query help

    I'm not sure if this can be done, but any help would be appreciated. I've created a query in access with about 10 columns. The first column is the key that combines the tables, and then the other 9 columns ihave null or not null values. What I need to do is pull all the records with atleast...
  4. R

    What does this mean? =IF(AND(OR(T2=B2,T2=C2),A2>0),A2, IF(A2>0,6,IF(J2=0,-1,0)))

    What does this mean? =IF(AND(OR(T2=B2,T2=C2),A2>0),A2, IF(A2>0,6,IF(J2=0,-1,0))) Im trying to find out if students have obtained the degree they originally applied for when entering the program. T2, B2, and C2 are all text fields while A2 and J2 are numerical. T2 is the original degree...
  5. R

    Using And/Or in IF statements

    Can you use And/Or easily in VBA I.E. Could you say if(And(A1 = 10,B1 =10),or(C1=5,C2=6,C3=7)) So A1 and B1 have to be true, and either of the "C" ranges could be true, for the whole thing to be true? Cheers

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