**[Solved] Using IF AND with Vlookup** *Summary*: Hi there, i am trying to find a way to come up with a formula to organise a sheet i am working on. Basically I need to do a few factors 1. If O=TRUE ...

**[Solved] How do i use the if function with a vlookup?** *Summary*: If A22 equals a number in the range from B5:B21 then I want the corresponding row number in column A in the range from A5:A21 to be displayed in B22 ...

**[Solved] Round and IF Function** *Summary*: I have a cell that is an IF function and it calculates if the value of another cell (A1) is in the thousands or in the millions. The result is a K or...

**Unable to use if function for comparing two days** *Summary*: I used if function to compare two dates from two different resources but it didn't work out. Here my sample: A1 B1 12/31/2013 ...

**[Solved] If statement with AND plus the OR function** *Summary*: How would this formula work in an Nested IF Function for Excel 2010? Column G--Salespeople who have worked for XYZ Security Systems more than seven ye...

**how do you write a macro for the IF function below** *Summary*: in excel; A1 = -0.02 A2 = -0.03 B1 = AVEARGE of A1 + A2 = -0.025 If B1 is negative, add A1 and B1, add A2 + B1 If B1 is positive, subtract B1 from A1,...

**[Solved] IF Function w/ dates** *Summary*: Hello! I have a set of colums with the dates of every step of a given process (the date that each step was accomplished). But for some of the processe...

**[Solved] how to create nested if function for date and military time** *Summary*: cell A1 has military time, 04:25:00 condition if the value of time in A1 is between 07:00:00 and 15:00:00, then B1 should display "a"; if the value of...

**[Solved] Changing colour of text in a cell** *Summary*: I would like to change the colour of text in a cell when the text changes based on the value in another cell. I am able to change the text in cell (in...

**[Solved] Nesting or within if function** *Summary*: I have two pages to my spreadsheet (criteria and quote). I need a formula in quote F12 saying that if there is anything in criteria C10 or D10 or in...

**[Solved] Excel 2010 if function** *Summary*: I,m trying to create a function to do the following -- IF CELL A2 IS LESS THAN C2 DO NOTHING IF CELL A2 IS MORE THAN C2 THEN REPLACE C2 WITH A2 Any so...

**[Solved] Excel IF Statement & Data Validation** *Summary*: I have a drop down list (A14) with different ports and depending on which port is selected, cell C16 gives you the corresponding value. The problem I ...

**[Solved] Excel 2010 IF function with Dates** *Summary*: I have a spreadsheet with dates in the format DD-MMM-YYYY (ex: 22-MAR-2012). I want to use an IF function to classify these into 3 different time fra...

**Can a function create tags and can If include functions?** *Summary*: I was wondering if a function can create tags for cells (Example: Cells C2-C8 have a value of either 1 or 0, depending on if one wishes to 'focus' on ...

**[Solved] MS Excel - Three Conditions for IF Function** *Summary*: Can you please help me create a formula for the following conditions: I have 4 columns: Column D - Total Reviews, Column J - Reviews Which Came for Ca...

**[Solved] If function to show whether it is in A,B,C or C+ sta** *Summary*: Field A1 Enter a reading (1077). Field A2 Set reading. Field A3. A1 - A2 = 4 Now this 4 will be in a specific standard. -3 to 3 = A Standard -3.1 to -...

**[Solved] Looking for an IF AND AND function?** *Summary*: Is there a way of creating an IF AND AND function in Excel? Is there anyway to create an if function that will work out if one cell contains "X" and a...

**print if function results in different colors** *Summary*: print if function results in different colors. if cell is less than another color, print in RED. if cell is equal or more than THAT cell, print in B...

**vlookup and if function** *Summary*: I need to weigh the parcel and base on the weight to calculate the delivery fee. Can excel have a function or are there any ways to do so? Are there w...