and if

Hi everyone, i have tried my best to write the IF statement i need but unfortunately i get lost in it. I believe that the below image depicts accurately what i am trying to write. I though maybe breaking down like this would help ne write it, but still i get lost in the formula. If someone could...

Hi All Looking for some help on a IF AND formula. I have a spreadsheet with multiple tabs, I need for the formula to look at one tab range of cells and another tab range of cells and if the range of cells includes two true value, return a value. I have been able to get this to work when im...

Hi all, I am struggling with this for a while... I have the following excel sheet as an example data set Column A Column B Column C Column D 1 First names Last names Fruits...

Working on metadata for a music library. I'm having problems with an IF formula, there are five possible outcomes for the cell named "Tempo": Unspecified Very Fast (131+BPM) Fast (111-130BPM) Medium (90-110 BPM) Slow (0-89 BPM) In my formula, S2 is the BPM value of each song =IF(S2<90,"Slow...

Hi I feel like this is probably a bit must to ask but lets see - i have 3 pieces of data for Income / Debt / Credit. For the purpose of this A1 = Income, B1 = Debt and C1 = Credit i need to create a % score based on 4 variable produced by those bits of data. IF B1+C1 = A1 "0%" IF B1 + C1...

Hi all I'm hoping you can offer some advice please!! I have googled as much as I can to get to this point. I have a workbook, and I would like some coding that identifies if a contract is a "Contract - Framework" AND has a status of "Contract Awarded" on the "Procurement Tracker" tab. I would...

Hello, So my brain doesn't have the power to figure this one out so if someone has the cerebral capacity to solve this I'd be eternally grateful. Attached is a 'calculator' that works out the volume of chefs wear needed for each of the hotels within the hotel group I work for. The plan is to...

<tbody> Day Train Passengers Fri 702 5 Fri 752 10 Fri 757X 20 Fri 737X 2 Fri 738X 1 Fri 700 100 Sat 738X 100 </tbody> <tbody> List 702 752 757X 737X 738X </tbody> I want the sum of passengers that meet the following two criteria: 1)Rode the Train on a Friday, 2)Rode...

Hi Mr. Excel, I am stuck on the following formula. =IF(OR(Nmd1>="200",Nmd1<"300"),SUMIFS(A1,Nmd2,'Sheet1'!$A161),"0") Nmd1 & Nmd2 are both named ranges that link to data in a pivot. Example as follows "=+'DATA PULL DOWN FROM SYSTEM'!B4995" This formula works, but I need this to return the...

Hi, I am having problems combining the HOUR, IF and AND functions in a formula and I'm hoping someone can assist. In cell A1, I have 09:00 and in cell A2 I have 17:00. Cell A3 has the following formula: =HOUR(A2-A1-1). This gives me 7.00 hours which is what I want. The '-1' is used to...

My control value is D46. My data is A7 to A141 for the min number and B7 to B141 for max, and C7 to c141 for the amount. I used the following formula and it works perfectly. I need to include all the data down to row 141. Is there an easy way to include all the values from rows 7-141? (other...

Hi, I am using Microsoft 2010 and I am trying to create a tracker so that I can see when my training certificates are "in date", "out of date" or "due for renewal". I have a cell C1 with today's date. I have the dates of expiry of certificates in B5:B7. I would like to generate a formula...

Hi - I hope that someone can help me with this spreadsheet for my scouting groups waiting list. This is what i want to do. If i have a child's DOB in a cell, another cell (say A3) then calculates their age at today's date. This is what i want to do in another cell. If cell A3 is less than 6...

I need my COUNTIFS formula to only count if one of the people who appears in column F is also one of the people in a range on another tab here: =Key!V2:V12. So in this formula below, A_List_Import!$F:$F,'All Dates'!$A$501 is just looking for one person. But I need it to count it if the person...

Hi I want a formula that does the following: If Cell C2 = Year 2 ($B$3), then Cell C3 = 60% and then D3 = 40% with E3, F3,G3 all zero If Cell C2 does not equal B3 , then Cell C3 = 0 so if Cell D2 = $B$3 , then D3 =60% and E3 = 40% and all cells afterwards F3, G3, are zero.....and so on

Hi! I have been racking my brain trying to find a formula that will do the following: IF I3 states "Not Recv'd" to return "Not Recv'd" but if no text exists in cell I3 then perform this formula IF(J3>=I3,"1","0"). Can anyone help me put these together? Thanks! :confused::confused:

I am trying to work on a 5 day a week 6 - 2hr slot daily schedule for the month of October. On one sheet I have the time of slot in Column A (4 thru 33) and on that same sheet I have a popup calendar that inserts the day of the event in Column B (4 thru 33). On the second sheet I have a...

Firstly I want to work with field I3. I should input there a formula that compares H3 with all the values in column B and returns the Fields that are equal to H3. Later on it should check field A* where the star is the correspondent field in A of the field that was equal with H3 in B. If one of...

If number is 1 to 4 show "Scene 4" If number is 5 to 9 show "Scene 3" If number is 10 to 24 show "Scene 2" If number is 25 to 35 show "Scene 1" And if number is 0 or above 35 show "Invalid" Please help.

I need a formula in cell U3 If the value of s3>=5, then add the value of T3 with a cap of 5 if the value of G3>=25 but if the value of G3<25 add the value of t3 with a cap of 3 only if s3>=3 HELP!