ifs and

  1. N

    Marco, IFS and XLOOKUP but certainly happy to be wrong

    I am really struggling with this and while its just the first part it technically controls everything else. Say I have 18 (I've only shown 12) rows and the data represented in these rows are dependant on a table (for want of a better word) The table contains 4 pieces of information which will...
  2. G

    HOW TO MAKE IF STATMENTS INTO ARRAYS

    hey there, im trying to change a co-workers if statements into an array if possible im trying to validate that If Colum AA is 1 or greater then to check if Colum AQ is between 7.3 and 8.3 and if its anything else to check Colum y and if there is a date then colum AQ should be zero, if there isnt...
  3. N

    Multiple sheets, multiple criteria formula excel 365 and Google sheets

    So after many hours and lots of assistance I am nearly there. What I would like now is the following, this is my current formula: =SUMIFS(Group1!$N$3:$N,Group1!$D$3:$D,"<="&$B$14) I would like to add to this formula is 3 more criteria. That formula is in H14 and I would like to add H13...
  4. 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...

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