I am trying to write a formula using If statement to output the result "True".
I have 4 columns (P3, T3, AD3, AK3) that store a value of either "Yes" or "No", I want to check the column if they are equal to "Yes". I have written a formula but it only works for 1 column at the minute, i not sure how to add the other columns into the formula:
I have a worksheet called "Raw Data" where in columns J, I and G contain values. I would like to write a formula whereby if all 3 conditions are met, it will count the number of values found in column C.
I've tried to write an IF statement but it just returns FALSE, despite the result being true. Need the right combination of IF/AND statements that would do this?
=IF(AND('Raw Data'!$J:$J="Maintenance",'Raw Data'!$I:$I="Open",'Raw Data'!$G:$G="1-2008"),COUNT('Raw Data'!$C:$C)). I've tried to attach the workbook, but there's a problem with uploading attachments I think. Sorry if my explanation is unclear.
I've got a formula that has numerous nested IF statement and am trying to get the true result to be the first of a given month of the current year. Here's my formula:
Everything works, save that the cell becomes 1/1 with no year at all. I've messed around a bit with TEXT and various DATE/MONTH/YEAR functions on this one, but can't seem to get it correct.
I have a formula that I'm trying to utilize VLookup to determine a specific bonus. The issue I'm having is when looking for the closes match, it is returning the value below where it should because it's rounding down. For example, the string I have reads:
=VLOOKUP(S5,'Rep Daily'!A1:B61,2,TRUE)
The value it's defining is 17.7485, so it's returning the bonus for 17.5 instead of 17.75. Even when I use the =Roundup function, it's showing 17.75 in the cell but the actual value of the cell is 17.7485 so VLookup is returning the lower of the two values.
I want to run a macro if the result of an IF function is true.
E.g. cell J55 contains =IF(H55>I55,"Goodbye","")
H55 contains =NOW()
I55 contains =DATE(2012,12,31)
Now by changing the dates etc. it prints Goodbye.... simple enough, but what I want is for it to run a macro that selects a range from the previous year's figures and simply changes the fill colour on the range. The macro for this also works fine.
I've tried using the worksheetfunction.sumif route and couldn't seem to get the syntax correct. I'd prefer the worksheetfunction route, as I don't need the formula stored, but it would be great to have both of these pieces of code for reference online - I scoured Google, and the examples I found were pretty weak.
I've recorded the macro (hence the R1C1 references in the second example) and had it work perfectly, but when I replaced row references with my variables, it went back to displaying "TRUE." I'm including all the code here.
Variables: expr = 3 to 38 (For loop) startrow = the starting row for the reference data endrow = the ending row for the reference data thresh = minimum threshold (a number)
I am new in Excel VBA and im trying to find a way to get back a result "True" or "False" when I have password, wich must consist of 6 letter, one upper case letter and a number must be in it. When this word consist of 6 letters and has a uppercase letter and number the result is True and this will be written into the cell next to the cell where the password is.
I have created the If statement below, in a nutshell its comparing current month performance to last month, stating if it has increased or decreased by last month and how much percentage by
example output would be 'This has decreased by x%"
my problem is when it states the performance has increased , the x% is coming as a negative number (-x%)
I want to display the path result from a Floyd Algorithm matrix output..
You can download the excel file here : http://ifile.it/lw4tgic It consists of 1044 nodes, and we need to find the path between 2 nodes for ALL pairs..
Now, to find the path between 2 nodes, we need to : 1. Find the resulting cell of corresponding 2 nodes (y to x = z) 2. Update the path with that value (y z x) 3. For all the direct pairs in the current path (yz, zx), find the resulting cell 4. If destination (x) not the same with result (z) then repeat step 1 for that pairs. 5. repeat until x = z for all pairs.
Maybe it's better if i use an example.... we'll use T01 to E78 as an example
T01-E78 = if you look in the table, y (vertical) = T01, x (horizontal) = E78 z (result) = E77, so
T01-E78 = E77, so path = T01-E77-E78
check if result of T01-E77 = E77 (x = z?)...........................
I am trying to create a formula to count the number of time the word "NEW" appears in one column, provided the result of another column gives a certain answer. Sample of my problem and question in detail on attached.
I am trying to put together an IF statement within excel which will give me certain output depending on the particular value within ONE cell.
For example:
If cell L5 has a value between 0 and 1.00 output value 0 If cell L5 has a value between 1.01 and 2.00 output value 20 If cell L5 has a value between 2.01 and 3.00 output value 40 If cell L5 has a value between 3.01 and 4.00 output value 60 If cell L5 has a value between 4.01 and 5.00 output value 80 If cell L5 has a value between 5.01 and 6.00 output value 100
On sheet 3 column d i have a vendor number. I am trying to create a formula in column M (same sheet) that will say "True" if the vendor number in column d is also listed on sheet 2, column A (Rows 2-148)
Write if statement or any other formula: if cell C3 is less then 0 then "over due", if = 0 then "due" and if more then zero then "not due yet" otherwise preferably nothing, because that would mean that the cell is empty.
Here's what I want in a sentence: If one of the cells in grouped row is "T", column B = True, if not then column B = False. (row groups are separated by a blank row)
I need to make an IF statement that when it's true it need to retrieve the values from a different column. With what function is it possible to just retrieves values?
I need to return the value from pivot table. Forgot to mention this.
I'm looking to use an if/and statement to give back a true of false but it doesnt seem to be working, I'll give an example, I want excel to search a set of cells to see if its blank and another cell to see whats written there(from a pull down menu) and if both of them are true I conditionally format to go green, otherwise stay white. It works for one cell, condition below:
=AND(Anoop!B3="IIC",NOT(ISBLANK(Anoop!C3)))
but I cant get it to do this =AND(Anoop!B3:13="IIC",NOT(ISBLANK(Anoop!C3)))
i.e search the entire column
I was also wondering if it was possible if it found an "IIC" in B8 how I could get it to check C8, D8 etc..
I am using MS Excel 2010 want what to change a number of cells if a value is true e.g.
Row one has the headings Prz, Stat, Val, andPts Row two has the following values :- (Prz) a2 =2, (Stat) b2=1, (Val) c2=$30, (Pts) d2=10 How do I do the following in Excel :- IF B2=1 THEN A2+1 AND C2+30 AND D2+5 so that the above cells are changed to (Prz) a2 =3, (Val) c2=$30, (Pts) d2=10
Excel 2010, I have the following list (showing part of it):
Name T-Shirt Sizes Nathan S
[Code]....
The aim of the list is to see what Sizes each and every person needs and then count how many T-Shirts are required for that particular size. The list is over a 100 entries long so counting it manually isn't really an option as it's time consuming as well as errors might arise.
Thus, I've been trying to use the IF statement with the following logic but to as no avail
IF Size in Column is XS Add 1 to a particular Cell IF Size in Colum is S Add 1 to a particular Different Cell
and so on for the other sizes...kind of like a counter for a for-do-loop.
I have a line of code that compares cell values with a variable.
Code: dim rmycell as range If rmycell.value = MyTarget then
This works fine when rmycell.value is empty or has a value. However, sometimes rmycell has a #VALUE! Error. When debugging the code I can see this error showing rymcell with a value of "Error 2015". The MyTarget variable is "abcdefg", so the If statement should resolve as
Code: If rmycell.value = MyTarget then becomes Code: If Error 2015 = "Abcdefg" then
Which should be a negative result. Except it isn't. The code that is conditional on a positive result runs whenever there is a #VALUE error, just as if the 2 values were equal.
I have a line graph that will not show the result of an IF statement. I have deleted and recreated the graph, linked the results to different cells, but nothing works.
Is there a way to tell Excel to sum only up to a certain point? Like if A1 through AF equal 50, but I only want it to sum up to 40, to stop at 40?
Is there also a way to tell Excel using IF that if a statement evaluating a number is true or false, to return the value up until a certain number. For instance, if the value is 8 or less, then it should return that number, but if it exceeds beyond 8, say for instance 12, then if the value is 12, only return 8.
Is it possible to write an if statement to display a picture if a cell contains a certain value? Ive got if statements nailed, its not a problem with that i have, just the returning of an image, rather than text ar a hyperlink.
Eg, "if cell A1="stadium", to show a picture of a stadium in cell C1"
Is there a simple solution, by changing something in the button properties? My current code below allows data from a userform to goto specific sheets and cells. Currently my option button named winbutton if true will display "true" in cell. i need it to be numerical value "1".