if function

  1. L

    Using the IF Function within Excel

    I am trying to work out a calculation within Excel and my values for 'arg' can lie anywhere between -10 and +10. Within a cell, I would like to work out how to use the IF Function to say: If the value of 'arg' is greater than +1, then the value will be changed to +1. If the value is less than...
  2. S

    IF function not working correctly with calculated value

    So I've run into a strange issue with using IF to compare whether one calculated value is less than or equal to another. The function works correctly in most situations, but in some cases it's incorrectly showing that the second calculated value is greater than the first when they are actually...
  3. J

    VBA or IF & OR function for algorithm

    I need help automating an algorithm, where A is the Nr., that is freely inserted (i.e.: 12, 500, 175, 4, ...). Cell C should recognize the number (as <100 to >5.000) from cell A, and the risk level accordingly on cell B, from No to High and present the result on cell C. There is a second table...
  4. V

    Indirect function with relative movement

    Hello everyone, I'm currently using the indirect function with the IF function to identify if O111 is equal to N112. The problem that I have is if I delete or add any rows the indirect function won't move to follow the last value on the O column. Do you guys have any ideas on how I should...
  5. U

    Vlookup alternative or if function

    I have data in multiple excel sheets in the same workbook. All sheets have the same table but different data as each sheet represents a certain date. The name of shops in the table are chosen from a dropdown list and you can see the full list of shops to the right of the photo. What i want to do...
  6. K

    Can someone please help me with the nesting of IF/AND functions?

    What I need, is if AB17=yes, then if X17=In-State, $7.50 but if X17=Out-of-State, $13.50. But if AB17 is blank and/or doesn't =yes, then no response. This is what I have so far: =IF(AND(AB17="yes",X17="In-State"),"$7.50","$13.00")
  7. R

    IF / AND with exceptions

    Hi All - Looking for help with a problem. I have an IF function with an AND inside it, the AND has multiple rules. Currently, the formula works great but I am looking for one of the AND rules to allow for an exception based on words in a separate cell. Current Formula...
  8. T

    Transposing a Column into A Row Alphabetically Based on Criterion

    Hello community, I have a challenge that I am currently unable to overcome: In one worksheet, I have two columns; one entitled 'TYPE' and one entitled 'PRODUCT CODE'. Under TYPE, you will either have the word 'ALPHA', 'BETA' or 'OMEGA'. Under PRODUCT CODE, you could have one of a huge...
  9. S

    Extracting a number from a text string and returning a third value

    Hello All! I have one Excel file In Column B (275 rows) I have a number (all of these numbers are unique) In Column C (275 rows) I have a string of text which contains several numbers within the string (all of the text strings are unique) In Column D (275 rows) I have a different number from...
  10. B

    IF function giving error... do i need to add AND function as well?!

    Good Morning All, Having issues with my IF function formula, and i'm sure its user error. For the life of me, can't figure out what issue is and how to resolve. Any help would be greatly appreciated. On my sheet, i'm trying to compare orig dates (Column A) vs actual dates (Column B); easy...
  11. B

    IF Formula - nested

    Hi, I need to create an IF formula based the following information (my goal is to have a column with hourly rate per employee, whether they are hourly or salary so I can do a vacation accrual - see details below): col BC this column says either SALARY of HOURLY on each line (by employee) col...
  12. W

    If Formula to calculate cell with value

    I am trying to create a formula that will create a result for a cell if a range of three cells has a value: IN K6-------> IF D6 contains value multiply G6 by 15 IF E6 contains value multiply G6 by 15 IF F6 contains value multiply G6 by 10 Each row (6-xxxx) will have a value in ONLY one cell...
  13. Y

    If Function to Copy a different cell value into another cell and change different cell value

    Hello, My first post because I usually find my answers without asking :) So here's my issue: I'm trying to create a formula, using IF Function maybe??, that copies certain cells from one sheet to different cells in another sheet and change a cell value on the first sheet, but the cells are...
  14. 1

    Loop through code and then run if statement

    Hi, I am trying to loop through all cells in the range J10:J25. When a cell is smaller than the value in cell "D12", I want it to change color to red. This is probably simple, but I am unsure how I can target each cell to check for the if function. ActiveCell does not seem to work. I could...
  15. sdkorin

    IF function

    I need a little help with what I thought would be a prettysimple if function; however, the solution seems to allude me. I have 3 columns. Column H is going to generate text (“Yes”or “No”) based on what’s in columns I and J. Columns I and J are for dates someone is certified in aparticular...
  16. B

    IF function

    I have 25 information cells, in a separate cell it will tell me which box to get my information from. I want a formula in another box to show the information from that cell. If cell A says 10, I want cell B to show the information in cell 10; if it says 25 in cell A then I want box B to show...
  17. P

    Summarizing date table to monthly closing

    I have a table with four columns (ID, Date Taken, Date Return, Amount). The Date Taken & Date Return column only closed yearly. <tbody> ID Name Date taken Date returned X1 XX 16/11/2017 31/12/2017 X2 YY 1/1/2018 15/5/2018 </tbody> From that table, I need to derive number of days for...
  18. H

    I don't understand why my formula won't work?

    Hi! If anyone could help with this, that would be very very helpful! I am trying to identify in Cell U2, people who either missed a class many times in once month, or consecutively missed classes in the following months. So I would like Cell U2 to say "TRUE" if either S1 or T1 say "TRUE". I...
  19. T

    Using Multiple IF Functions in same expression

    Hello, I am trying to change the values in my Status column to either Overdue, On Track, or Blank. These will reference my Due Date column. I have figured out how to have my cell = Overdue or On Track, but am having difficulty adding an additional layer to the formula. Currently, I have...
  20. G

    Excel for counting, sum, sort by models and maxim limit

    Hi, I'm facing a challenge and I am sure that there is a way to deal with some help because there are smart people around...;) I have different products per day, and I must organise to store them like that: each box can store max 60 products, every model in one box (if there is a different...

Watch MrExcel Video

This Week's Hot Topics

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