Summary: What is the formula for an IF statement to hilight any value or text, if that value appears more than one time in any given column? Using conditional...
Summary: Hi, I was wondering if someone could help me get an Excel IF statement right. I am making a test, and I need to convert the raw score into a standard ...
Summary: Could I please obtain some help creating an Excel IF statement, considering the following parameters: - There is a date in cell A1 - The statement wil...
Summary: I am pretty new to IF statements in the context of excel and have no idea how to complete the latest one I need. Basically Its like this: The are thre...
Summary: I'm am setting up a spreadsheet to track fuel consumption and hour of heavy equipment. I have conditional formatting set to change the color of a cell...
Summary: Your IF statement is incorrect. It is causing a circular reference which is confusing Excel. Since it can't figure out what to do in the cells with t...
Summary: If you really only have three columns of data, then you can do it with a single brute force nested IF statement. The problem is that any more than 3 c...
Summary: Yeah, what you need is conditional formatting. With it you can highlight cells and color them, depending on their values. The if statement won't forma...
Summary: There are 2 problems with the construction of your If statement. First, the syntax of an IF statement is: IF(logical_test, value_if_true, value_if_fal...
Summary: I have a set of dates in the format dd-mmm-yy in column a and have 2 conditions of jobs 1, 2 & 3 in column b. I would like column c to: - return the d...
Summary: basically, I want to put a figure in cell A1, in cell B1 i will have a yes or no. If in B1 it says Yes I want it to carry the figure over thats in A1 ...
Summary: I have 3 entries generated by if statements in 3 cells next to each other. D1, E1, F1. Based on the IF statement outcomes, only one of these cells wil...
Summary: I am trying to create a formula (if statement) that will do the following and need help? I am adding up three cells (G21+G21+G23)and dispayng the sum ...
Summary: I need some help creating an IF statement in Excel. If there is text in (G19) then I would like it so that (T19) produces a result if (S19) meets the ...
Summary: Hi, I have a question regarding if-statements in VBA. I have a time-series of interest rates (A2) and calculated the daily percentage changes (B2). N...
Summary: I have a column that has both blank cells and cells populated with amounts, there are no formulas in any of the cells. I want to change the blank cel...
Summary: As I suspected, you do not have anything set for the value_if_false for the final IF statement. Keep in mind that Excel evaluates the Nested IF's in ...
Summary: first test ur condition by having a formula =if(D1+....=0;"A";"B") to see what result u have to ur condition. I suspect ur problem is in ur vlookup: w...
Summary: Dear All, I have a small query on excel and conditional formatting. Here goes: I have a column that has all dates in them displayed as 02.08.2008 or 1...
Summary: I don't think they can be combined based on the criteria given. Let's break them down in detail... =if(and(g4="hn", g9="er"),"20.33","30.50") If the A...
Summary: You know what, I think I got it to work using your formula and I added IF(BP2<=.99,.09) to the rest of the formula. I didn't know that adding anoth...
Summary: Following is the example I use when trying to remember how to use AND or OR within an IF statement: =IF(OR(AND(A1>1,B1<10),C1=5),D1,0) i.e. IF (A1>...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
