I've got a list of marks (col T), and I want to create a new column subtracting 5 from each value.
Obviously, the formula in this new column is
=T1-5
=T2-5
etc...
But I enter that formula and excel doesn't do any calculating, it just displays "T1-5"
It even seems to recognize that it's a formula, highlighting T1 in the formula and the T1 cell itself, but no resulting value...
I've tried changing the format of the cells (in both columns) to Number and back to General again, but without success.
I've also tried copying and pasting (values only) the whole T column to another column, and tried there, also without any success.
I have data that when added together will have decimals of .1 or .2. Any decimal great than .2 becomes an integre of 1 and is added to the other integres. for example: 1.1, 2.0, 3.2, 5.1=12.1.
I now want to subtract this total from another amount that will give me values with decimals of .1 or .2, example: 59-12.1=46.2 not 46.8. The same if 62-8.1=53.2.
What is the formula for taking two times, and finding the minutes between them. E.g. 12:35 PM-12:28 PM=7. I know i can use (A1-A2)*1440, but is there an easier way?
I'm looking for a formula that acts the same way as the subtotal formula (revises if rows are hidden and only adds visible rows). Is there anyway to get this removal of hidden rows but for subtraction?
i need formula that will look in Col A and perform a subtraction in Cell b1 between 2 value dates 28/12/08 -12/12/08. Though I could have done this manually but was wondering if there is formula which will avoid duplicate dates. So the formula is set and when i copy new data in Col A daily the formula should be able to pick 2 dates regardless where the second date starts at...
Using Excel 2003. I have a very basic SUM formula I am using to show how many forms are still in-house. Pretty simple.
Column D is how many came in. Column F is how many were completed. Column E is what is left.
To get the daily count I take the previous day's Column E, add to today's Column D and subtract today's Column F.
=(E2+D3-F3) Puts the results in E3.
This formula is copied on down the worksheet which results in: =(E3+D4-F4), with the results in E4. And so on down Column E.
The problem is that if there is no data entered in Column D or F, the results from E are carried (copied?) as far down as the forumla. i.e., if today's column E results in 4, then that is displayed for as far down as I have copied the formula. What I'd like to do is set the formula so that if there is no data in columns E or F, then there is nothing displayed in Column E.
So I have a list of names, and I need to keep track of whose paperwork I have. There's a column that says Yes/No.
I would like to link everything to another sheet in the file. So for every name that says "No," I would like that name to appear in the next sheet. And when someone updates the first page to put in a "yes," I want it automatically taken off the second sheet.
I have a reasonable grasp of Excel and this has me completely stumped. Three cells hold numeric values (format General though the format seems not to change the result)
C4 = 4082322.25 D4 = 4046689.05 E4 = 35633.2
Another cell contains the simplest of formulae ... F4 = "=C4-D4-E4"
Clearly the result should be zero. In fact the result is (to 15 decimals) ...
0.000000000189175
HOWEVER If I change F4 formula to "=C4-E4-D4" the result is zero.
I would like to insert a formula in a column, the formula is in column D and must be something like "=C1-B1" for row 1, "=C2-B2" for row 2,...etc. I would like to do it without using a loop cycle in VBA...I have attached an example of the data I'm using..
down a column of about 3000 rows, yields only one cell with an unexpected and probably incorrect response in G2 with a "NO Match" - where the math is correct ?
A B C D 63.58 0.00 -54.97 match 64.57 0.00 8.61 NO match 128.21 0.0073.18 match 201.39
Details:
Attachment is included; temp2.xlsx
in a bank account file, where "C2" is the previous balance, "C1" is the current balance, "A1" is any check written, "B1" is any deposit applied.
I have used Excel for a number of years and have gotten on ok on my own working out simple formulas myself but I have been stuck on this one for a while. Is it possible to enter a value into a cell and have a predefined formula that works with the data that I enter?? I would like to enter a value between 1-10 and the cell then takes this number and multiplies it by a value in another cell. Eg.
I have a cell that displays £10 (let's say D6) In another cell I enter 8 I would then like the cell to do the formula =8*D6 automatically, as this value can be different each time (1-10)
I'm getting a mismatch error on my If activecell.value > 5 Then portion of this code. I'm trying to say if the value in column AG is greater than 5 then create an email address from the first and last name. I've even made sure to copy and paste the formula results as values.
Code: Sub CheckPFPDates() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim emails As String Dim salution As String Dim currenttime As Integer
I am trying to implement a simple macro. Here is my Function Age(DOB) Age = Int((Now - DOB) / 365) End Function
Sub Macro1() Age (Selection) ActiveCell.Offset(0, 1).Select ****** End Sub
The function basically calculates the persons age using their date of birth. What I need to know is how to copy the result of the function into the cell next to the selected one. (The code above only selects the adjacent cell).
Report I generate once a month that checks to see if tasks are done on or before their due date. Sometimes it works, and others it doesn't...
The basic formula is: [Code] .....
If they closed their task by or before the due date, the condition should be true and it should output "Compliant" beside their task. Otherwise their "Over Due".
The forumla works except when they close their task ON the due date. No matter how I tweak the forumla, it thinks the condition is false as if it cannot tell when the two dates match.
I am trying to use FIND and an array formula to find the position of text in a range of cells (A2 and A3 in the example) which could be one of a number of options (C1:D1 here). But the array formula throws up the following error: "A value used in the formula is of the wrong data type". The simplest illustration of the problem is as follows. The formula in B2 is
Code: {=FIND(($C$1:$D$1),A2)} and $C$1:$D$1 contain REF and ATM respectively. [/CODE] REF ATM 203047 05AUG 08.55 OKEHAMPTON ATM #VALUE! CO-OP GROUP 380611 REF 191 7553375222 BCC 22
We see that B2 has a #VALUE! error - wrong data type. But for some reason B3 is ok returning 22!
