if statement conditions

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

=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"

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