multiple if and or

  1. A

    Multiple If, or, and

    Greetings all - I would like very much to get some assistance with the following please, if anyone has thoughts on it. =IF(BB2="","",IF(AND($AR2="x",$AZ2="L",$AV2="C",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="O",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="B",J3>...
  2. S

    IF OR AND statement in one formula

    Hi all, Having a bit of difficulty here figuring out where I am going wrong with this one. The table below is for a lighting audit. The inputs are in red and the formula in cells J2:AG4 are for monday only. The data set continues AH and onward for each day of the week. I want to be able to...
  3. D

    IF , AND and OR formula help please

    I have a simple spreadsheet with 4 or five columns in. Column A and B have data validation which the user will drop down Column A = Team, Individual Column B = Winner, Runner up, NA What I am trying to do is in column E have a formula which looks for the results of A and B and inputs data...
  4. D

    IF with OR Function using wildcard characters

    Hello I can find thread explaining how to use wildcard characters with IF using COUNTIF but I am trying to find something that will search multiple columns to say "Y" or "N" if it is contained in either cell. =IF((OR(A1="dealing", AB1="dealing")), "Y", "N") The above formula would do this if...
  5. R

    Help with IF, and,or statement

    Hi all, im newbie here, i need your help to create a formula on (T30) with condition <tbody> IF (Q30)=(H30)OR(Q30)>(H30)AND(S30)=3 OR (S30)>3 then (T30) will be A IF (Q30)=(H30)OR(Q30)<(H30)AND(S30)=1 OR (S30)<3 then (T30) will be B IF...
  6. A

    Formula Help-Multiple IF AND OR Function

    This may sound like very basic, but I'm unable to put the formula correctly, Column I Column K ROW 1 10.00 100 ROW 2 12.00 220 <colgroup><col...

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