nestedif

Days of the week Sunday Monday Tuesday Wednesday Thursday Friday Saturday Days Number Day =IFERROR(IF(A10=1,A2, IF(A10=2,A3,IF(A10=3,A4,IF(A10=4,A4,IF(A10=5,A6,IF(A10=6,A7,IF(A10=7,A8))))))), "PLEASE ENTER NUMBERS BETWEEN 1AND 7")...

Hi, I need to perform binning on a time range using if else statement. Can anyone help me with the formula? I can't seem to get it to work... Attached is the excel screenshot to help show what I am trying to accomplish. Thanks.

Hello, I'm new to Excel and I've been going around in circles trying to figure out if I can even do what I need to via nested IF functions. Here is a screenshot of my what I have so far: The first IF function I need to populate in Q28 is IF(D28="N", "N/A", ""). I want Q28 to remain blank if...

Hello, I’m using Excel 2010 ( no comments!) and I have an extensive monthly report based on dynamic table and nested IFs but I wonder if there is a better and simpler solution. I have read some questions in the forum and it seems difficult to achieve the same results with a more elegant...

What is a less rigorous way or writing this? Sub COSTPLANBREAKDOWN() Dim rngstart As Range Dim tst As Range, lastrow As Long Dim cl As Object Dim L As Long, strcells As String, lsr As String, toplvl As String, comm As String, flat As String Dim CLT As String, PLT As String...

Hi Everyone, I need help about nested if. I have set of conditions that needs to be followed, unfortunately I dont know how to do it in Excel. Please help :( <tbody> WH Stocks Recommended Stocklogic Expected output 100 50 10 Recommended 100 110 50 Stocklogic 100 10 50 Stocklogic 0...

:rofl::rofl: I am simplifying a bank reconciliation by identifying each transaction on the bank and GL into categories. I tried nesting: =IF(T33="*DES:ACH*","PatientPayment",IF(T33="*CIGNA*","PatientPayment",IF(T33="*DXC*","Dental",IF(T33="*DENTIST*","Dental",IF(T33="*DES:DEPOSIT*","Other...

I am struggling to put a formula together for the below set of inputs: <tbody> Target achievement % payout 90% 0 95% 50% 100% 100% 110% 150% 120% 200% </tbody> So if the target was £1000, and they achieved £900 they get nothing, if they got £1100 they get 150%. I need to know the...

Hi, Can someone please help me to create a nested if? Basically, I want to check if a cell contains a string, and if not, check if it contains another string and so on. My cell is A2. If A2 contains the word "bracelet", A10 = "bracelet" If A2 contains the word "necklace", A10 = "necklace" If...

Hi, I am trying to allocate labor hours per week to meal periods using the employee time clock activity. My meal periods are: Breakfast 6:00 AM - 12:00 PM Lunch 12:01 PM-6:00PM Dinner 6:01PM - 12:00 AM Late night 12:01 AM-5:59AM The time clock activity gives Time in and time out. Most employees...

Hi, I have a large spreadsheet that I receive often from a lab that I need to perform some statistical analysis on. I have been able to get what I need from nested if statements with regular cell functions, but I fear they may be confusing for my colleagues and am hoping for something a bit...

Hi, I am looking for someone to help me create a formula. I am trying to pull text data from multiple sheets that may or may not contain the data I am looking for; so something with only False in it I assume because if it's true I don't want that data. Is there a way to do this with VLOOKUP and...

Hello - I'm trying to write a formula to hyperlink a cell based on the value of another. So far I have this: =IF(A14=5, HYPERLINK(sheet1!A1, "friendly name"), HYPERLINK(sheet2!A1,"friendly name")) But am getting a "Reference is not valid." error and I can't figure it out what I'm doing wrong...

Hi there, I'm comparing data from two different sources and need an efficient way to do it. I have one Excel workbook with two sheets - RAS EpSelect 0101-0106 and RAS HCP 0101-0106. Both worksheets have mostly the same data but is distributed over different columns. The data I'm using has...