if funtion

Hello, I'm having trouble with a nested formula, PLEASE HELP If Type is Edit and Video is Y then Points=3 If Type is Edit and Video is N then Points=1 If Type is Published and Video is Y then Points=4 If Type is Published and Video is N then Points=2 See attached File

I am trying to pull the data from the first row (E1, F1, G1 ...) based on a certain condition. If col D - "Penetration limit" is equal or greater than the data between row E to V, i need the row name(E1, F1, G1 ...) to show up under the respective col C. Example: in Row 4 ---- D4= 40% and N4...

Hi All, Please forgive me if I do not explain myself clearly; I am rather new to Excel. I am trying to create a formula that will populate a cell with text depending on an entry in 7 other columns. Only one of the seven columns will have an "Yes" entry. This is what I have so far that is not...

What I am trying to do is make excel populate information automatically from one sheet to another. I'd like to say, "IF the value in ANY of the cells in a selected column are greater than 1, then populate the information in the ROW cells from which the column cell is located." I.e. if my...

All the data is not sorted and filled one by one in order throughout. 1 3000 2 2950 3 2700 4 3000 . . . 59 2350 60 2400 if there is not data in row 60, the formula should show data in row 59 and so on. The problem is "if" can't fulfill all the condition. "Lookup" doesn't fit also. How...

Hi all, im looking for a way of using named cells instead of nesting IF functions, im going to work with 2 BIG IF functions, in the case im working out I can use a VLOOKUP function but I need it for instructional purposes.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...