if and combine

  1. M

    Nested IF AND function in IFS function

    I need to update the below formula to include this piece: IF(AND(Rate_Card_Selection="Company B",C19="Remote Access Points"),0,150)) What is the correct way to nest the IF AND function into the below? =@IFS(C19="Company A (London)",325,Inputs!C19="Remote Access...
  2. C

    IF statement for consecutive cells

    Hi I'm trying to write an IF statement that will tell me if 3 consecutive zero's appear in the row of another worksheet. I also need the statement to tell me if there are more than 3 as well.
  3. Q

    Conditional Formula with Mult Conditions and Mult returned Values (Text)

    Hello, So I am a Newbie to this forum and have read several of the post but have not been able to find the answer to my issue. I am trying to create an IF/AND formula to score a students' assessment Student is assessed in three fields and received one score for each field. Final score is a...
  4. M

    Two If Statements in One Formula

    I am trying to have two If statements in one formula. I am trying to have all cells from C3:C32>5% in addition to cells I3:I32>1.9% highlight. I do not want it to highlight unless both criteria is true. If both are true I want the cell in I3:I32 to highlight. Please let me know I really...
  5. S

    combine 3 If AND statements

    Hi Can you help me in combining 3 statements below in to one line to i can put in one cell. They work fine on each cell but need to combine. Ive got one column with "high" "Medium" and "low" in there and one column with numbers in. =IF(AND(D2 = "High,",I2 > 3),"FAILED High","PASS High")...

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