if statement conditions

  1. A

    Adding a Negation to IF Statement with Text

    Hi, I have the following formula, but need to add an additional piece where I'm stuck. IF(AND(ISNUMBER(SEARCH($A$1,B3,1)),(H3-G3>3600)),C3*30,H3-G3) The formula searches for the text "LEASE" in B3, it then calculates the difference between two dates (H3-G3), if the result is greater than...
  2. H

    Assigning a reference to unique values in a range without sorting

    The title is perhaps not very clear and not sure if this can be done - BUT any idea how I allocate something a reference number but meeting certain criteria. What i'm trying to do is to say if the product (col B) is live (status col A) and has a certain code (col C) allocate the first...
  3. J

    How do I create an IF Statement that contains a data validation option

    I am filling out a list of capabilities that have sub-capabilities. A2 is the Capabilty Name A3 is the Sub-Capability name B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A" In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a...
  4. J

    How do I create an IF Statement that contains a data validation option

    I am filling out a list of capabilities that have sub-capabilities. A2 is the Capabilty Name A3 is the Sub-Capability name B2 is drop down list (data validation ) with selections of "Yes", "No", or "N/A" In B3 I am trying to create an IF Statement where if B2="YES" then I am presented with a...
  5. W

    Unknown Logical Test in IF formula

    I have a logcal test in an excel if statement that I don't understand, this is a nested if, which I understand completely, my trouble is with the last logical test: IF(1.16 > B32 > E38 .................. What does this do? Does it test if 1.16 is greater than the value in B32 and then test if...
  6. B

    Excel VBA: IF Then Else not working

    Hi Everyone, I am trying to execute what I thought was a few simple lines of code but it is not working as expected. The test that I am trying to execute is if there are values greater than .07 then print them on another worksheet, however it is printing everything including values that are 0...
  7. A

    Selecting evaluating people using excel

    Hi I have 100 students in my class and there's an article that I want them to submit. Also I want 5 of the students to evaluate each other's articles. All the students have a unique number. Can someone please suggest a formula for the same? PS I don't want any student to evaluate his or her own...
  8. S

    If Statement Issue

    Hello all I am having an issue with a formula in my spreadsheet. I have run out of thought on my formula. Background. I have stores I'm looking at for periods of time for sales comp. That information is in cells A-K. Column L is a pretty straight forward formula to tell me if the store is...
  9. M

    PowerPivot DAX Conditional IF automation or reference

    Hi, I would like to create a column in the powerpivot data table that will change upon updating a master date or criteria. I have a functioning If statement that works well: =IF([year]=2010,[count],0) Which provides the result that I need when I hard code the number 2010 into the if...
  10. E

    Case or If statement

    I have the following code to change a cell's color based on certain conditions. I am comparing the values of two cells on the same worksheet. I have tried this with If Else If, seperate If statements and Case statements but cannot get it to work. Any clues would be appreciated and Happy...
  11. H

    If Statement Question

    Is there a way to return the actual value of a cell IF the two cells are true instead of just returning a text string
  12. L

    Macro to call macro if cell = 0. Please help. Wife's job depends on it.

    I have a macro button named "AddLine" that shifts cells down from E thru (End Right) as long as I start in column E. I want to test each line and if A = 0, run the macro "AddLine", if not then move down a line and repeat. I tried the following but it only inserts from the first row (which...
  13. J

    Conditional formatting - Or statement for 10+ different text words

    Hi I've created a food journal and I want certain words to highlight in red that are junk food. So far, I've been creating them individually, but would rather do one long condition to include all the text words that I want. So if the cell value is = milk, soda, fries, pizza, beer, chips...
  14. R

    Adding a Series to a Scatter Plot Based on Conditional Check

    Hello All, Bare with me here :) I have 3 columns: | A | X | Y | | 0 | 59 | 61 | |20 | 58 | 60 | |110| 58 | 60 | I want to add a series (a subset of data from columns X and Y) to my scatter plot based only on rows where the value in column A is <101. (The subset I want is Bolded...
  15. A

    "If" Statement Not Running Even When Statement is True

    Hello all, I never thought I would have so much trouble trying to do simple user error checking. I have a little block of code that asks for a user input, and then it checks to see if the input is valid (numeric and between 1 and 7). The if statement runs when the entry is not numeric, but if...
  16. S

    add another criteria to an IF formula

    =IF(AE2<=30, J2,IF(AE2>30,V2)) This formula works fine; however, I need it to also be based on column AF=0. I've tried (and , but can't seem to get the sequence correct. If col AF=0, and AE2<=30, return J2 If col AF=0, and AE2>30, return V2 if col AF isn't = to 0 "conditions"
  17. C

    IF Statement help

    I need some help with an IF statement. I am checking a code vs another code cell. The appears ###/####. What I want the formula to check if the referencing cell is <= to other, and then return one of the respective text strings I enter for true and false. I believe the issue I am having is...
  18. J

    Help regarding IF statement based on text and consecutive dates

    I have been working on a spreadsheet on excel 2010 tracking the number of items a student can acquire. One student can have multiple teachers (uID). Items can be tested once or multiple times in a day. From columns A to E lists the raw data while column G contains filtered data of unique items...
  19. V

    If statement triple condition

    Hi everyone I have a problem that I couldn't work out can anyone figure out this. The table has a column of Zero, One and Two now the logic is here because I don't know how to formulate this. See this table below <tbody> A B C D 1 ZERO(0) ONE(1) TWO(2) OUTPUT 2 0 0 1 2 3 0 1 0 1 4 1 0...

Some videos you may like

This Week's Hot Topics

Top