Dear all I have to add and subtract the values of some cells.So that's the case In the first column i have the codes of account which have in the first part...

I am having trouble finding the formular for column F I have typed in what i think it should be but it keeps returning the wrong...

23/06/2008 00:00:00 25/06/2008 00:00:00 2.00 3.00 =a2-a1 =NETWORKDAYS(A1,A2) 2 dates in cells A1 and A2, a subtraction results in 2 but the networkdays...

I need a formula to produce a true or false result based on if a cell H71 (with a formular similar to this =(G71*$I$1)+G71 matches the figure in another cell...

Hi, Please find the excel sheet entry as below.I need to find whether the values in coloumn A is available in the coloumn B or not.Presisaly,i need to find...

I need your help. i'm trying to to look up the exact value of a variable or the closest match that contains the exact value. for exampel, if i try to lookup...

I have information exported from an accounting system into an Excel spreadsheet. The export has 3 columns; the first column contains the value of the first...

Hi ... I have 4 columns in one sheet with emp name, project name , start time and end time per day. In another sheet I have time (column) and emp name...

I am try to find data on table1 and return data from table2. (discount rate and Full rate) by enter data1 and data2 then enter formula to one off the cell to...

Hello, Can anyone help me please? I need a formula to count non blank cells within a rolling year. (The dates are in the top row, and the days/occassions...

If say, cell A1 contains a formula (example =(6.14/3) and I want to perform a calculation that refers to this cell say =(A1*36*60) I will get a slightliy...

The figures shows like 3.212,25- i like to konvert it to the figure -3.212,25 and be able to calculate on the figure -- Palle korsholm

¿Es posible hacer un salto de lÃ*nea dentro de una celda? ¿Cómo?

Hello I am trying to find a formula or something that allows me to convert a number to a text in Arabic Im using the NBTEXT for the english numbers so what...

Hi All, I've a set of data taken from a running machine's server. What I want to do is to track the board's serial number changes for a particular position...

I have information exported from an accounting system into an Excel spreadsheet. The export has 3 columns; the first column contains the value of the first...

I am trying to count the number of titles of cost entries per quarter. I used the following formula: =COUNT (IF B6:B11= "Expenses"). The problem is no...

I have been struggling with a formula. I cannot figure out how to do it? Help me please!!!

i want to setup some sort of formula to search a column for specific keywords (multiple keywords as well) and return a value from an adjacent column...

how do i create a formula that looks at mutiple column and gives a value ie, if column "a, b, c, d" has "Yes" value, then "e" should display "123".