# ifformula

1. ### IF formula

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)
2. ### Return Blank with an IF Formula

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...
3. ### How To Use VLOOKUP Using Date, To Find Corresponding Holiday With Additional Criteria

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...
4. ### Switching between formulas

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...
5. ### IF Formula

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
6. ### Help with correct formula please

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...
7. ### Using IF formula on a DATEDIF cell

Hello, does anyone know how to use an IF formula with DATEDIF as the logical test?
8. ### IF Formula/Conditional Formula Help

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...
9. ### Using Vlookup/If to extract values from one named cell in a big data spread sheet

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...
10. ### Nested IF formula with wildcard

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...
11. ### Formula - Comparing 2 cells continously

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...
12. ### Getting Rid of an #DIV/0! Error

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...
13. ### Nested IF formula not working

: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...
14. ### IF with INDEX & MATCH

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...
15. ### Date Formulas with IF ?

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...
16. ### Need Assistance with multi-condition "IF" formula

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...
17. ### Blank cell when a corresponding cell left empty

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...
18. ### Use IF formula to reference data within a formula?

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!!!
19. ### Indefinite/ Multiple Vlookups until hit blank column.

<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...
20. ### Formula Error

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back