I'm creating a work schedule and currently the excel allows me to select from a drop down using data values. What I'm looking for is a way (formula) that recognizes a duplicate in the cells I have listed below. Yellow is Names drop down (don't care about duplicates there. White has drop down for...
So I want C2 for example return one of four things depending on what is in D2 and E2.
If both D2 and E2 contain "Current" then I want C2 to say yes.
if either D2 or E2 contain "Due soon" I need C2 to say "Due soon"
If either D2 or E2 say Expired then I need C2 to say expired
If both D2and E2...
I got such great help earlier today, I thought I'd ask for another favor. Scouring for answers didn't seem to help. So my situation is, I've created a drop down in B1 that has 4 options. Each option has a records retention rate associated with it. I would like cell B2 to reflect that rate based...
Hello,
I'm a complete newbie here and am somewhat familiar with excel, yet I have the challenging task (for me) to develop a spreadsheet that will calculate different record retention destruction dates based off of a value in one cell. So, for example, Cell A1 has a retention value of 3 (3...
Excel.pdf - Google Drive
Here is my question:
The last column is my total column and I’d like to put 3 if statements. If the totals in the Over/Under column are as followed.
IF the number is a negative in Column R put N/A in column T
IF the number is a positive in Column R put in Bold and...
OK, friends more capable in Excel than I, I need help creating a single cell that includes a date calculation and an if statement on a date range. A1=Date; A2=Date+3 Day; A3=Date+10; A4=Date+45. Date is something like 7/1/2016, for example, and the following cells just add to that. That’s easy...
Here are my three formulas:
in R6: =IF(K6="","",CHOOSE(MONTH(K6),2,2,2,3,3,3,4,4,4,1,1,1))
in Q6: =IF(K6="","",YEAR(K6)+IF(MONTH(K6)>=10,1,0))
in P6: =IF(Q6="","",("Q"&R6&" "&"FY"&Q6))
R6 finds the Fiscal Quarter of the date in K6
Q6 finds the Fiscal Year of K6
P6 combines the two results...
Hello,
I am building a function to where I would like a cell to reflect differently depending on what another cell reflects. Simple I know but the kicker is that I would like it so that is the cell does not equal a specific word then the cell will reflect a normal addition sequence of data:
I...
Im an English teacher and i want to select a lesson by the unit number(cell C3) and the lesson number(cell D3)
when i select the unit and lesson it must pull up the lesson info from cells A23-A46
and display it on my note cell(cell G3)
here is my formula and it works just the way i want it to...
I have 2 columns and I need the formula to read column "A" first and if it meets a certain criteria to look at column "B" and count if there's any text in the cells. See the example to show what I'm looking for. I would want the formula to look at column a for pet type (e.g. dog) and then look...
I am using this formula =(J5*((1 + I5)^C5)*E5) in Excel 2010 in Windows 7 enterprise to determine payroll raises and incentive raises. My problem is when E5=0 for no incentive raise then it returns "0". which I know anything multiplied by 0 will equal 0. SO how do I get the =(J5*((1 + I5)^C5)...
I am currently trying to adjust a formula for our time sheets. The current formula takes into account when a person works over 8 hours to consider that "banked" time (comp time). I now have an employee that will be working 8 hours one day a week and 6 hours the other 4 days. The current formula...
I am creating a page tracking water sample results. There are 4 numbers in each result. I would like to have a cell that will track it if any one of the numbers is above a certain range, not all.
Here is my current formula... =COUNTIFS(H6:H22,">5",I6:I22,">0",J6:J22,">200",K6:K22,">500")
The...
Theres a couple things i want to do in one cell.
I have three cells.
The first two cells B6 and B7 have two values
In the third cell B9 I have an existing formula =ROUNDDOWN(MIN(B6,B7),0)
It works great, it inputs the lower value of the two. Now, heres my problem.
In the same cell B9 I...
hi all. i have an xls training matrix sheet where the source data consists of expiry dates corresponding to peoples names. these names are are then repeated at the top of the sheet and using conditional formatting I have a traffic light system of green when they are within date, amber within 30...
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.