if statement alternative

Hello! I have a a big dataset where I've used the conditional formating to color values that are grouped as: The values are in percentage of the total in that specific dataset, so all values are somewhere between 0 and 1. Above 20% : green traffic light 19,9% to 5% : yellow traffic light and...

I have a table where I record the start time and end time for Frac and Wireline operations on a well, and that process is repeated for each stage of the well. Sometimes we skip stages and no times are entered indicating that skip which messed up the Total Time calculation. I left "Stage 3" (Row...

I have a Spreadsheet that has employee Names in Column A Payrate in Column B in Column C Total Hours. I am trying to add a 1.5% increase to the employees who make more than $14 an hour and bring up the employees that make less than to $14 an hour. Then I need it to return the total amount they...

I am using Excel 16.13.1 Mac Background: My formula currently measures the percentage of completion between TWO dates based on a "current date" input. and IF the percentage is under 1 (or 100%) it does so If it is 100% or higher is says “Complete” Current Formula: O7 refers to Start Date, Q7...

I'm trying to nest multiple IF statements, along with IF(AND(OR) statements within one cell. The "Premium Table" I have to use is below, along with a sample of the the worksheet. The question is: What IF statement do I enter in cell D2 to obtain the correct premium? Premium Table Age Range -...

I am trying to figure out which elements of a set of numbers (amounts) total to a target value. I am creating a google sheet to keep track of what my roommates pay me, where I receive both full and partial payments of bills from my roommates but documentation indicating what bills are being...

Hi, I am trying to find a single formula that allows me to recognize whether a company has the following; Has multiple products in both Product Ranges Has single products in both Product Ranges Has multiple products in a single Product Range Has a single product in a single Product Range I...

Hello, I have a list of shifts I did with the date. This list expands as I do more shifts. <tbody> A B 1 Shift Date 2 1 date 1 3 2 date 2 4 3 date 3 5 4 date 4 6 5 date 5 </tbody> I have another list of deliveries (on another sheet) with the shift given, I want to automatically...

Hi I am trying to figure out what appeared to be a simple formula however I thought wrong. Does anyone know how to have a SUMIF apply if a cell contains a certain text? Here is the formula that I have now, which is not working... =SUMIF(AJ1:BC1,"=*Reserved*",OR("=*Actuals*"),AJ2:BC2) What I...

Pardon, I know this is rather confusing...I'm just having trouble thinking of how to simplify this and wondered if anyone had any ideas they'd care to share. I started writing a formula recently with a bunch of nested IF statements that's kind of spiraled out of control. I'm wondering if anyone...

Using Excel 2010 I have a created a project plan in Excel where I am trying to make the start date of one task begin when another task ends. For example, my start date column is F and my end date column is H. My predecessor column is B. So if I need the task on line 30 to begin after the task...

Hey folks! I am trying to enter a formula into a single cell that has a few different arguments - seems easy right. The issue I am running into is that the decision is made based on criteria that fall within a range. For example: The formula would be in cell A2 and would reference D2. If the...

Hello everyone, I need to find an alternative formula to "IF", because my need now surpasses the maximum allowed nested if statements. Cel C21 contains color names and cel D21 needs to produce the color code associated to the color name in C21. There are over 100 color names. I used to use...