nested if or and multiple

Hi, I have a problem where I have price data from one company and want to allign it to our products. Basically saying, if product A falls under these measurements it is in group 1. If Product A is in group 1 and has a weight of 1 KG the price is 1,00 but if the product is 2 KG the price is...

Hi, I have 24 different sub-Processes and all has different deadlines, for e.g. Sub-Process A needs to be completed in 24 hours from the received date. Sub-Process B needs to be completed in 10 Business days from the received date. If from the drop down a sub-process is selected and received...

Hello Excel Gurus, I have three different text file formats from three different programs that I'm trying to import into a spreadsheet to optimize coordinates data. I already have safety nets put into place in the event that the user cancels the file import, or if any errors occur during the...

Hello! and thank you for helping me find a solution to this problem. Right now I have a very long nested function that has around 200 if statements and left functions. The function works great, but I can only go as far as 64. The purpose of this function is to get part of a string in a cell and...

Hello and thank you so much for being here! I am constantly coming to Mr Excel to learn new techniques, but this one has me stumped. I am trying to have the oldest date listed in column F (Other than the blank ones), for rows where column K = 1 and column G = TRUE.........I always get the date...

Hi all, I am trying to create a headcount file for forecasting in excel. I have a Date of Hire (DOH) and date of termination (DOT). The problem I have is with my "if" formula. Here is what I am trying to do: If(DOH is < = to (date), DOT = "", DOT > (date), then (1) or "" ). The problem I have...

You have to be a lot smarter than I am to figure this out. I wish I were fluent in the language of Excel, but I am not. How the rest of you get this stuff is beyond me. Thanks for taking a look.<o:p></o:p> I have sorted this out the best I could.<o:p></o:p> <o:p> </o:p> <o:p> </o:p> IF AD2 =...

I have a time sheet that was working great, until I needed to figure night shift hours. I have columns for clock in/out and lunch in/out. I also need columns to show the number of regular (normal pay) hours and the number of OT hours. C = clock in, D = clock out lunch, E = clock in lunch, F =...

Hey All, I am trying to nest a function using the following formula IF(OR(AND(AN4>=AM4),J4<=0,K4<=0,),"TRUE","NONE") I am getting a result, but the result is not what I need. I want the formula to read as 'If AN4>=AM4, AND either J4<=0, OR K4<=0, then "TRUE, if not then "NONE".' Any input...

Hi I need to write an If Statement for a sports picking list that accomodates the following rules: Display error if: 1 - Term 1 = Rowing + Term 2 = Swimming 2 - Term 1 = Rowing + Term 2 = Swimming + Term 3 = Tennis 3 - Term 1 = Rowing + Term 2 = Swimming + Term 3 = Tennis + Term 4 = Squash...