-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
nested or statements
-
B
Nesting IF AND OR all together
HI, I have a question card with 5 questions 1,2,3,4,5 going down column A1, A2, A3, A4, A5. I would like to work out the percentage of the score where the answers can be from 1-5 in column B next to its respective question number. BUT the questions can also be answered 0 if not applicable and i...- b19upj
- Thread
- nested "if statements" nested and statements nested or statements percentage formula
- Replies: 4
- Forum: Excel Questions
-
B
summarize
I need to summarize data from 4 sheets in a workbook into one master sheet within the same workbook. The 4 sheets represent different employees and the data are the accounts they are responsible for spread over 12 months. There's a billed, paid and difference row. The summary sheet needs to...- breifcase78
- Thread
- nested and statementes nested if statements nested or statements summarize tabs into one
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
How to sum values of the year till 31/12 and reset to 0 on 1/1 for years running totals?
- Started by LRATOZ
- Replies: 38
Howdy, I have been recording rainfall data since 15/11/2015. I used to have mutiple sheets for each year but I've learned that it makes more sense... -
Auto filter between a range of dates
- Started by K1600
- Replies: 37
I am trying to apply a filter to a data set which is with an excel formatted table (Table8) but the first bit I need to do is only show data where... -
Formula to Display Sheet Name of Worksheet that Contains Max Value Across Multiple Sheets in Workbook
- Started by erino
- Replies: 36
I have created a workbook that is comparing my business transactions from year to year. Each year is represented by a worksheet (2020, 2019, 2018... -
date formula to determine amount of vacation weeks
- Started by bh24524
- Replies: 32
I am looking for help on a formula that will look up a given seniority date contained in cell C11. The formula would be in D11. I want it to... -
Inserting IF formula in complex index/match formula to get results until certain date
- Started by SteveNL86
- Replies: 28
Dear reader, I'm using this formula... -
Nesting INDEX MATCH into SUMIFS
- Started by lost_in_the_sauce
- Replies: 26
I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...