logical formula

Checking a outside model that I received and the if statement false value is referencing the cell in which the formula is being written. If I try to recreate this, I obviously get zero, which is not the value the cell in the model is returning when the logic is false. My question is, how is an...

So I am pulling out my hair here, trying to figure out why over the last two months, this formula has been working, and now it stopped. I have duplicated my previous work to the letter, I have double, triple, and quadruple checked my data sets. I have named and re-named my ranges to ensure they...

Hi, I currently have the formula below looking a set of data comprised of people and percentages. The formula currently looks at if a person is in the bottom 20% and are below the target (0.815). From this it produces either a 3 if they are both below target and in the bottom 20% or a 0 if...

Ok I'm not sure what I am doing wrong, can someone help? Each of these formulas on their own in a cell return the value I want (the first IF returns the Initials next to the Begin and Deadline date ranges in the correct areas, and the second returns DONE if there's a date in the completed...

Hello, I need a formula to compare a single value to 4 variables and return TRUE or FALSE. In the table below, the answer should be TRUE when the Pick value matches the Color or the Shape AND the matching Color or Shape has the higher % (within the row). If the Pick value matches the lower %...

Hi, I'm sorry the title sound weird, I need to use various formulas (or one long formula) with conditional formatting and this is the scenario. I need to display different message if some condition match. i have 3 dates and range that sometime have string sometime is blank Date1 -> Cell G12...

NEED HELP!!! I want to find the MIN and MAX from column 'values' with respect to dates. Data is in below format (each date has corresponding 1440 minutes and each minute has a specific value): Dates (several months; daily_basis) | Time (minute by minute) | Values (data) Required Result...

Hi There I have a three shifts 06:00-14:00- Morning 14:00-22:00- Evening 22:00-06:00- Nights I have a range of times E2 Column such as 18:44 21:49 02:59 06:54 (ect) I want to return in the column next to the time if the time falls in-between the shift times whether its a Morning, Evening...

Looks like my calculations today are kinda slow since im looking into improve or get some results. i have the following: <tbody> name survey count current score failed survey good survey survey goal anderson haley 44 89.00% 4.84 ¿? 92.00% </tbody> assuming that D2 is =B2-(B2*C2)...

Hi All,</SPAN> I have searched high and low, so apologies if this has been asked before.</SPAN> I am not sure if I am pushing Excel further then what it is cable of</SPAN> I have a work book with a table that goes from A12 to Z468 that is used for reporting purposes. </SPAN> My header row...

I am looking for help writing a formula to distigush between varied text formats. I want to play out like: IF(B1 = "STRUCKTHROUGH", 1, if (b1 = "RED", 2,3)) <TBODY> YES <S>MECH</S> YES MECH NO MECH </TBODY>

How to resolve this problem? :confused: If I have a combination of 125x10 in cell A1, then I just need the number after the "x". So, the value in cell B1 is 10. Example: A ____________B 1 125x10 ________10 2 53x5 ___________5 3...

I am attempting to use conditional highlighting to highlight duplicate values in a range of data in excel 2007. Here is exactly what I want: Column A is a function of a 'toggle switch'. So if I change conditions of the toggle switch the values in column A change. Columns B through N have...

Hello I'm trying to write a formula to count cells c3,e3,g3 etc. but only if they contain a specific formula - i.e. "=count(b3)" There's about 40cells I will need to count from. I've tried =countif((c3.e3.g3 etc),="%count%","0") but is coming back incorrect. Hope that makes sense...

Hello Not too sure if this is possible, but looking for help with the following formula. =IF(AND(Training_Plan_2011.12!H9,"COM 1"),(Training_Plan_2011.12!A9,"7-Mar"),"Training_Plan_2011.12!I9","") I'm working across spreadsheets and basically trying to get excel to input the value of a...

Hi there Please can somebody help me with the syntax for a formula requesting the following: =if(c4,"£117.60"=>,"1","0") Not quite sure to put the => or if this is even possible? Tried a few variations and coming back dudd. Basically need the formula to input a 1 if the value of C4 is...