multiple formulas in cell

  1. X

    Drop Down with no duplicates in the cells

    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...
  2. L

    If both cells contain Current return yes, if both cells contain expired return expired AND if either cell contains due soon return due soon

    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...
  3. J

    Formula in one cell to return number based on drop down selection in another cell.

    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...
  4. J

    Need formula to perform two different date functions

    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...
  5. L

    How can i use 3 if formulas in 1 cell?

    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...
  6. N

    Date Calculation with Second Formula For Date Range

    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...
  7. zakasnak

    Multiple Formulas in one Cell

    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...
  8. F

    IF Function Question

    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...
  9. D

    Multiple Formulas in one cell

    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...
  10. R

    Multiple Functions

    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...
  11. J

    Calculating employee raises and incentive raises

    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)...
  12. C

    Writing formulas for time sheets

    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...
  13. M

    Using both COUNTIF and OR inthe same 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...
  14. S

    need help with multiple formulas in one cell

    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...
  15. T

    conditional formatting with multiple formulas

    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'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