if statement conditions

  1. 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
  2. Z

    If statement with multiple criteria

    Hi, Can anyone help me building the if statement as below logic? ABCDEFG1AmountCommentsStatus (Yes/No)2$0yeslogic to buildif Amount is >0, then "yes", and if amount is equal to 0 and comments column is not blank then "yes", otherwise...
  3. M

    Macro vba to assgin a formula to the variable

    Transformed(PRow * (c - 1) + 1, 39) = "=MAX(X" & Sum & ",Y" & Sum & ")-INDIRECT(ADDRESS(ROW(AC" & Sum + 3 & "), 28+X" & Sum + 1 & "))+ INDIRECT(ADDRESS(ROW(AF" & Sum & "), 28+(X" & Sum + 1 & "+1)))" Value 0 must be assigned to "Transformed(PRow * (c - 1) + 1, 39) " if the value is negative. So...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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"
  20. 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...

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