ifformula

To be specific: I need cell B8 to show the value of cell D100 only if cell B3 is equal to a special value (17), OR show value of cell K100 if equal to a different specific value (29)

Hello sorry if this has been posted before but struggling with this as I am not 100% Tech Savvy. I am trying to work out the formula to add to the below where I want the cell to remain blank if nothing is in the requested formula cell but every time I do this is it either enters the word...

Hello! I am looking for a way to do the following: 1. Use a given date in Sheet1 2. Go to Sheet2 and lookup the exact date from Sheet1 in table1, column1 3. If the date isn't listed in the table, end. (aka "") 4. Using date from Column 2, go back to Sheet1 5. If there is data present for the...

I need to switch between 4 formulas based on 4 criteria. The criteria are in two fields (2 criteria in each). I handle it using the IF statement, but the whole formula is so cumbersome...

Can you please help with a formula that does the following for the screenshot attached? if sum(E4:I4)<E12, give E12-SUM(E4:I4) IF SUM(E4:I4)>E12, give E12-E4 but IF E4="" , give E12-F4 IF F4="", give E12-G4 IF G4="", give E12-H4 IF H4="", give E12-I4

Thank you in advance for your time. I am relatively inexperienced with excel and am unsure whether what I am trying to achieve is possible. Some assistance would be greatly appreciated. Cheers. I want a formula that will display a number from 1 through 6 dependant on the value entered into the...

Hello, does anyone know how to use an IF formula with DATEDIF as the logical test?

I am attempting a simple reinvestment strategy. In the scenario shown below every year in which the store hits $5,000 in Running Sales, an investment of $5,000 is made to open a new store. So in theory, a year in which $10,000 in Running Sales was generated 2 new stores would open. However, a...

Hi, I am wondering how I can easily extract wanted data from a spread sheet that is connected to a SQL-database sorting values in random order. Lets say the data is sorted like his: (as you can see, they are not sorted with same intervals all the time) 1 A E 2 Savings...

I am setting up a spreadsheet to collect monthly figures. Of these figures I want excel to automatically calculate a percentage using two figures. I have this formula just fine. I want to have the formula present for all future months so that when I input the figures it automatically calculates...

Hi All, Im trying to think of a formula which i can use and drag down without having to do it manually everytime. For example, im comparing Cell Value L2 against L3, in Cells M2, and M3, and then id want to compare L4 and L5 in Cells M4 and M5 and so on. Is there any one of doing this and...

I am calculating an average from another workbook and am trying to get rid of this error without having to insert a 0. I have tried an IFError but cannot figure it out. This is my formula: =AVERAGE('\\netapp5\group\CommunityServices\^Department\Aquatics Files\Batherloads\Monthly Batherload...

:rofl::rofl: I am simplifying a bank reconciliation by identifying each transaction on the bank and GL into categories. I tried nesting: =IF(T33="*DES:ACH*","PatientPayment",IF(T33="*CIGNA*","PatientPayment",IF(T33="*DXC*","Dental",IF(T33="*DENTIST*","Dental",IF(T33="*DES:DEPOSIT*","Other...

Hi, I need to tell my formula to search for one specific value in two different tabs. I currently wrote this (and it's working): =INDEX(' table (2)'!I2:S727,MATCH('TEST'!P3&'TEST'!Q3,'table (2)'!G2:G727&'table (2)'!H2:H727,0),MATCH('TEST'!R3,'table (2)'!I1:S1,0)) I have two conditions: BLUE...

Hello, I was wondering if someone can help me in creating a formula based on dates. I need the formula to be able to tell me the month of a set date depending on the day of the month. The criteria is: If the start is after 1st of the month, populate the following month, if not use the...

This is the first time I have been unable to find the answer to a formula question on these boards before, so I figured I would finally post a question myself: First, some background - I work with multiple clients, who each submit cases to me. My boss recently asked me to begin tracking whether...

Hi all, I'm sure this is incredible simple for someone in the know but as I'm still a beginner I'm in need of some help :) I have recently collected a sheet to measure how long my team are taking to send out free samples to our customers. In Column G is the date the request for a sample was...

Hi All, Is it possible to search the data within a formula rather than the text that the formula produces? I would like to return a value if a cell references a specific cell. i.e. =IF({A2 references C2},"Yes","No") Thanks in advance!!!

<tbody> ID Vlookups? Col1 Col2 Col3 Col4 1 34 45 2 20 25 29 30 3 10 </tbody> Hi All - I have the following table. First column is an ID. The following columns (ignoring Vlookups) are a number of additional IDs that relate to the IDs in the column. (e.g. IDs 34 and 45 are inputs...

Hi Excellers, I have a formula I am using to count if an instance occurs. =IF($D$10:$D$100="Backs",SUMPRODUCT((MOD(ROW(H10:H100)-ROW(H10),2)=0)*(H10:H100)),0) but I am getting a #value error I can not figure out what I am doing wrong. "the search "Backs" will change on various lines but 5...