## If function Related Problems & Solutions

19 tags
Refine Tags
Search Tags:

Results 1 - 19 of 19
[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...

1