conditionals

  1. C

    Average Conditionals?

    I am trying to average some data in my excel spreadsheet basically it looks like: <colgroup><col><col></colgroup><tbody> 1 5 2 6 3 5 4 6 1 5 2 6 3 5 4 6 </tbody> I need to average the first set of 2-4 and then the second set and so on and so forth and I am looking for an easy...
  2. J

    Conditionals and how to use the FALSE output in a cell

    I have written a few conditionals and the output of those functions are FALSE. I want to use that fact to write other conditionals. So, if cell 1 conditional reads FALSE, I want to write a conditional in cell 2 that uses the output FALSE in cell one. However, the FALSE output in cell 1 isn't...
  3. J

    Trying to look up a value on one spreadsheet from another

    Hello, This is my first post and I hope I can articulate my question well. Basically I have a spreadsheet I have to reconcile every 2 weeks. in one column on my target spreadsheet I have city stations such as: ABE ACV ORD I need information from another spreadsheet that has a column with city...
  4. N

    Sumifs with Conditions across multiple sheets using indirect.

    I created a formula that compares an existing list with names linked to total sessions selected from list on different sheets and once the criteria is matched the sessions are tallied in the formula cell. My initial formula would be to difficult for people to change and it's sluggish. I tried...
  5. J

    Lookup up a data set (Sorry for the reposts, the site froze as I posted)

    I want to allow a workbook reviewer to review each of three different scenarios by typing the numbers 1, 2, or 3 into a cell in order to populate a table of data from three data sets. My first instinct was to use conditionals: =if(C3=1,B2,0),if(c3=2,C2,0),if(c3=3,D2,0) While I see the logic...

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