if statement

  1. H

    Vlookup in Power Query with If statement

    Dear All, I am trying to do a Vlookup with if statement in Power Query but unable to. in Excel I have done in this way --> =IF(P3="Recruited",VLOOKUP(AA3,'Sheet1'!A:B,2,0),) Please if you could help me on how to do this in Power Query? Many Thanks.
  2. FrumpyJones

    Having trouble with conditional formatting on IF formula result

    I have the following formula that works fine to either give me a result or leave a cell blank if the value is zero...
  3. N

    Need Help With IF Functions with Greator Than and Less than signs

    Im having trouble writing a If statement. The problem is to write a statement that determines whether the infant is greater or less in weight than the overall average, and assign a 1 to those greater and a 0 to those less. Ive tried a few things but i am struggling to get it to cooperate
  4. R

    Help with If statement

    Trying to automate some math for price updates. Unit of measure in E1, price in F1. Trying to reduce all pricing to each price. If E1 = 'EA', F1*1 If E1 = 'C',F1/100 if E1 - 'M',F1/1000 Here is what I have so far, any help would be greatly appreciated...
  5. D

    How to automatically replace Excel formula with value when date condition is met

    Hi, I have been trying in many ways but I have not been successful to record the results of a constantly changing cell. Value changes daily and depends on other variables external to the problem. This is the case: Cell A1 value is changing, and I need to record the value of A1 at specific...
  6. D

    Building a formula contingent on non-consistent signals

    Hi all, I have been struggling with this excel puzzle for a while now. Hopefully someone can help me out! I am testing a trading strategy where sometimes we have to 'get out' and later 'get back in' again based on some rules that I would like to put together in a formula. I've tried to...
  7. L

    Formula to return the value of the duplicate number

    Hello, I am trying to find a formula to return the value of the duplicated number in cells that are not right next to each other, but within the same row. In the below example, I need a formula in column I that does the following: If the variance to on-hand in column D is zero then return the...
  8. L

    If function help

    Novice here.. Can anyone help with the below formula? It seems to be working for the first condition but not the second IF.. Column BC contains the values 'Y', 'N', and blank. So the second IF should run if BC is not 'N' (BC would be 'Y' or blank) IF(BC2 = "N", U2="NO"...
  9. R

    Force Balance to Total

    Hi there, I was given the task to force balance the data in 'Q1_2024_Raw' to sum to the final total by GEO (i.e. all LATAM customers need to sum to 10, so in this case I need to force balance their data down from 20 to 10 and all NAAM customers need to sum to 100 so I need to force balance up...
  10. O

    Copying rows based on text in cell if not already existing in new sheet

    Hi, I want to check column D:D for the text "Offentlig" and copy the entire row into another sheet. But if the row already exist in the other sheet i dont want it to copy and paste it, which my code does. If a new row is added with the text "offentlig" in the corresponding D cell i want this to...
  11. S

    IF Statements for Dates with VLOOKUP and Concatenate

    I am still a newbie to most Excel functions. I have created a workbook with IF Statements, VLOOKUPs, Concatenates, and VBA Codes. However, due to an annual rate increase, I need to create a complex IF Statement for just this month and I can't quite wrap my head around how to do it. Currently...
  12. S

    VBA: All combinations that sum between two numbers - too much processing blows up

    Hi, Thanks much in advance for reading. It's really not an overly confusing concept, and I've tried to lay it out as simply as possible! I have some VBA code (not my own) that successfully returns combination sums between a defined range. A quick summary of what that even means, then my issue...
  13. B

    If Multiple Conditions

    Hi Everyone, Struggling with three different scenarios; scenario one: if Column Row says "New" return "new", scenario two: if scenario one is true, but date is less than 2/1/2023 return "transfer", scenario three: if scenario one and two are true, if balance is greater than (>) past month...
  14. S

    VBA using IF OR THEN statements and returning the product of cells in two columns.

    I need to write a VBA code multiplies the cells in columns J & K to return a result in column L, if the value in the cell of column H is L or O. For example: Since H21=L, then L21=J21*K21. The columns will never change, but the rows will change every month. This is what I have written, but...
  15. B

    IF formula question

    New question for everyone, I'm trying to sum the prior month balance of all loan ID that are no longer in my current month as it was paid off. I can use this formula but adjust some values right? For some reason I get it to lookup all balances. =IF(Table2[@[Loan ID]]<>[@[Loan...
  16. F

    Drop down list IF, VLOOKUP Statement

    Hey Team, Is it possible to have an IF statement imbedded in your drop down list that automatically fills in your selection depending on a cell value?? In the below example I have a drop down list for my "TYPE". Id like to add an IF statement to my drop down list that would work as follows...
  17. E

    How to Stop Running Turnaround Time

    Hi everyone, I was able to figure out how to produce a running TAT however, I am now running into the problem of stopping the running turnaround time for one of my columns. The short idea is that I want to have an If Statement nested inside my existing formula so that when my F column is not...
  18. K

    Use one cell to conditionally set the value of another cell

    Hi. So I have a situation where I would like to manually input data OR have a formula calculate a value for a certain cell. The situation is as per the table below and is for a travel logbook. The formula in B4 is obviously not correct but describes what I want to do in excel terms. Start...
  19. C

    Find and Replace Macro for Excel (If x exists then replace y with x) - For Microsoft Excel

    I created a macro in excel that runs a specific report for me and it works beautifully. I want to upgrade this macro to replace the "Insert Association Name" with the name of the specific community. That community name can be found in every report in the details column. For this one in...
  20. R

    How to force a user to select an option button?

    I've got a model with a code that should depend on the selection of one of two option buttons. When a user opens the model, the both option buttons are unselected. I need to make sure that the user selects one of them before the main code is run. So if nothing is selected, then it should display...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top