if command

Hi all, I currently have this formula: Right now the cell is showing a blank cell. I then have another cell that links to this cell through this formula: This cell also shows blank, because the first cell is blank. I then have a third and final cell with this formula: However, this...

Dear all, Please note that I made an earlier thread and am now continuing with the same sheets as before, but also including a new file (file 3). The old thread is here: Excel vlookup problems I currently have three files, file (1): File 2: And file 3: Currently, file 3 has the...

Hello I need to calculate the average value of a column contain temperature values (column H). The difficult part is that I want to average only specific cells of this column, that meet certain criteria. More specifically, I want to average temperature values from column H, only if the wind...

Hello Column A Column B <tbody> 1/1/2016 12:00:00 am yes 1/1/2016 3:00:00 am yes 1/1/2016 6:00:00 am yes 1/1/2016 9:00:00 am yes 1/1/2016 12:00:00 pm yes 1/1/2016 3:00:00 pm yes 1/1/2016...

Hello to all, I have a little problem in using summation of the values which in normal case results in adding all values but if any one of the cell contains a text (any text, not specific) then the summation should result to zero. I have applied this formula for values in cells from A2 to D2...

I have a list of regulations that each have a unique ID. The next column is a text description of what each regulation refers to. On a separate worksheet I want to be able to type in or select a reference in Cell C2 and have that description automatically displayed in the next column (C3)...

Hi, I have a table of info in in Column a has a bunch numbers all different. Column B shows names. i then have a separate spreadsheet with numbers similar to first spread sheet column A. I want to check that the number that is in spreadsheet 2 if it appears in spreadsheet 1 then to show the...

I have an assignment due soon however i cannot the the IF command working,well im not even sure if thats the right function to be using. But basically i want a formula so that excel displays a primary contact according to some rules. e.g. if the street number,address,suburb and postcode are all...

Hi there, I have a question about the IF Function in Excel 2007. I currently have a spreadsheet that's separated into categories, in specific by "Departments". Here's an example: [Column A] [1] Deparment=1209 [2] Food [3] Water [4] Clothes [5] Misc [6] Department=1211 [7] Housing [8]...