Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










X= Formula; Subtract The Number From Cell C32


in Cell J32 I want it so when i type in a number it would subtract the number from Cell C32. Is there a formula in which all you have to do is type the number without editing the formula?


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Formula To Subtract A Number Per Day
I needa formular that will subtract a number per day, for example as one day passes you can set the amount of number to be taken away from the total.

View Replies!   View Related
Formula To Subtract A Value From A Cell
I need a formula that will subtract a value entered in A3 from a valued entered in A2 to be displayed in A1.

Also...the Value displayed in A1 must be the value of A2 minus the running total in A3.

Ex...If I type '10' in A2 and type '3' in A3 the value shown in A1 must equal '7'. If I then type '2' in A3 the new value in A1 must equal '5' (this being the value in A2 of '3+2' minus from the original value in A2 of 10)

So..A2 = inputted value , A3 running total of inputed value, A1 differnce of A3 from A2.

Is this even possible? The whole idea is this....if you type a number into a calculator, and then subtract a number from the first number, the calculator then displays the new total. If you then subtract an number from that NEW total, the calculator then displays that NEW total. Thats what I'm trying to re-create in excel.

View Replies!   View Related
Subtract From Number On Right Of Alphanumeric Text
We use excel to organize salaries and contracts for my fantasy baseball league. I need an easy way to go through all the teams and subtract one year from each players contract. This is an example of a team.

The contracts are in the columns like this NG-3

I would like to change that to NG-2


View Replies!   View Related
Subtract The Lower Number From The Highest
I have name and a number in this

format: cell a1 Jones---56. In cell b1 I have another name i.e.,
Johnson---45. How can I subtract 45 from 56, take 60% of the difference
and in cell c3 show the following; Johnson---6. All numbers are to
rounded down to 0. The final result would look like this;
a1 Jones----56, b1 Johnson----45, c1 Johnson----6. I have other cells
with the same type of info in them. Example; a2 Smith----34, b2
Jones----78, c3 would show Smith----26.(rounded down) I always want to
subtract the lower number from the highest and take 60% of the
difference.


View Replies!   View Related
Subtract Number From Column Of Numbers
I have data on A1 to A100. How can I subtract a same number (for example 10)from each cell of A1:A100?

View Replies!   View Related
Formlula: Subtract Largest Number Then Average
I am trying to subtract the highest number from a row of numbers then find the average for the remaining numbers in Excel 2003, as: =SUM(B2:E2)-MAX(B2:E2)AVERAGE(B2:E2).

View Replies!   View Related
Subtract Decimal Number From Current Date
Need to find out exact date. if I insert 32.5 (32 years 5 months ) in particular cell. my output shld be 10 june 1974 or 10/06/1974. I want to find back date...

View Replies!   View Related
Formula: Subtract The Values
Need a formula that will subtract the values in X:Z subtracting the lowest value from the second lowest, then using that value and subtract from the 3 value. The outcome will always be positive and range from 0-9. Expected results are in Col AA. Then I need an adaption of that formula to read a 3-digit value in one cell.

******** ******************** ************************************************************************>Microsoft Excel - CASH 3 MID MOSTLY.xlsx___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutW1=WXYZAA111/30/094774211/29/099636311/28/091632411/27/097687511/26/095775611/25/097801711/24/093003811/23/097700911/22/0952851011/21/0990361111/20/09346512 13 1411/22/095285 1511/21/099036 1611/20/093465 Sheet2 [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View Replies!   View Related
Formula To Subtract Pounds & Ounces
I need to build a spreadsheet that subtracts from a cumulative weight recorded in pounds and ounces. For example, in a fishing tournament, a person has 5 fish to weigh. They place their fish one at a time in a bag hanging from a digital scale that reads in pounds and ounces, and record the cumulative weight as the fish are added. We want to know what the total weight is of all 5 fish, but also what the individual weight is of each of the 5 fish.

The easy way to do it is to place the first fish in the bag and record the weight, then place the second fish in the bag with the first fish and record the cumulative weight of the 2 fish together. Continue this until all 5 fish are in the bag, and record the final total weight.

Then, to get the weights of each individual fish, the first weight is as it is, the second fish weight would be Cumulative Weight recorded for Fish 2 minus the weight of Fish 1. To get the weight of Fish 3, you would subtract the Cumulative Weight for the first 3 fish from the Cumulative Weight of the first 2 fish, and so on.

For example:

Weight of the Bag with:
1 Fish: 1-lb 2-oz
2 Fish: 2-lb 14-oz
3 Fish: 5-lb 6-oz
4 Fish: 9-lb 7-oz
5 Fish: 11-lb 9-oz.

We can subtract the cumulative weights to determine the individual weights of each fish added to the bag and know that:

Fish 1 is 1-lb 2-oz
Fish 2 is 1-lb 12-oz
Fish 3 is 2-lb 8-oz
Fish 4 is 4-lb 1-oz
Fish 5 is 2-lb 2-oz

Easy to do in my head, or on paper, but not so easy to do in Excel because it's pounds and ounces, which is how the digital scale reads out. But, when you're doing this for 20-30 fishermen, it's not that easy to do it on paper.

View Replies!   View Related
Formula To Subtract Invoices From Total Amount Available
I have 2 tables, one with invoices, the other with purchase orders. I would like to have a "PO Amount Remaining" column on the invoice table that looks up the PO listed on the invoice with the PO $ amount on the PO table. Once it is matched, I would like to subtract the total invoices to give me the amount of the PO that is left. Basically I would like the "PO Amount Remaining" column right now to have $4,200 listed in each row for invoices 1 & 2.....

View Replies!   View Related
Formula That I Can Add, Subtract, Divide, Average, Etc, Etc These Numbers
Imagine I have cells A1 to A5 with a sequence of "numbers" like this:

A1 = 50-55
A2 = 45-67
A3 = 56-90
A4 = 49-80
A5 = 51-55

The left hand side numbers represent a score a minus sign (-) to separate and the right hand side represent another score. I want a formula that I can add, subtract, divide, average, etc, etc these numbers.

If I want to add the left hand scores, for example, cells A1 to A3, sum would be 151 (50 + 45 + 56).

View Replies!   View Related
Match/Index Formula :: Multiply Last 3 Cells In A Row And Subtract 1
I am having a little trouble with multiplying a few formulas. I am looking for a formula that will multiply the last three cells in a row that contain data and subtract 1. Below is an example of the type of data I am working with and the formula I am trying to use but is not working. The formula is for the cell highlighted in red. Every quarter the last three cells being referenced will change.....

View Replies!   View Related
Use Number In Cell With Other Number In Lookup Formula
I'm trying to use the formula vlookup, but running into trouble. I'd like to use =VLOOKUP(3000&A1,E:F,2,0) but this isn't working correctly because it doesn't recognize "3000&A1" as a number? Is there a way to do this? This will be used in a VBA code, so I prefer the solution in VBA, but either way is fine. See attached for more info.

View Replies!   View Related
Subtract Start Time From Finish Time Return Hours Worked As Number
I have a user form with textBox1 = start time (entered as "[h]:mm") and text Box2 = finish time (entered as "[h]:mm"). I would like textBox3 to display the difference between the start time and finish time as a general number!

For example
Start time: 21:00
Finish time: 06:30
Hours worked: 9.50

Start time: 12:30
Finish time: 23:00
Hours worked: 10.50

View Replies!   View Related
Subtract Cell From A SUM Total
would like a very small macro for the following:

Units units remain day 1 day 2 day 3 ... day 13
MACRO

The units are the total number of units that can be bought ( in a game) and these are purchased on a daily basis.

I would like a column " units remain" as units are purchased to just count down auotomatically as numbers are entered into the daily row.

Thus:

11 xx day 1 day 2

Where xx would chage as numbers are entered into day 1-13 ( these will be either 1 or 2).

View Replies!   View Related
Subtract Cell From Others Based On Cell Content
I am trying to create a formula that will compute a variance between the numeric value in a given cell with the value in one of 3 other cells depending on the condition of the 1st cell. Example: If the Value in cell F4 has a condition defined as "PMR" in cell C4, subtract the value in cell F19 from F4. If the condition is defined as "DBR" in cell C4, subtract the value in F20 from F4. And if the condition is "OTH", subtarct the value in F21 from F4.

View Replies!   View Related
Automatically Subtract Multiple Values In The Same Cell
I wish to have a column with say 100 in it as that will be the initial stock levels

I would then like the next column to be blank so that when you enter say 25 (the number of stock taken away) the third column will show the new number of 75.

Simple? well here is the tricky part

I just want those three columns so the blank one in the middle will remain blank after it has been used so for example

on monday we sell 25 pencils and type 25 in the field and the new total is 70

on tuesday we sell 40 pencils and type (in the same field the 25 was put in the day before) 40 and the total will show up as 35.

View Replies!   View Related
Balance Sheet: Take The Value In The First Cell Of The Expenditure Column And Subtract
I have is a cell with a begining balance and a cell witha current balance.

I also have a column in which each expenditure will be placed ina cell in that column in sequential order.

What i want to do is take the value in the first cell of the expenditure column and subtract it from the begining balance and the place the result in the current balance.

But after the first cell i will need to subtract each value from its previous value to continue counting down so to speak.

I am at a loss on how to move the last value which will also be the lowest value in the column to the cueent balance cell.

View Replies!   View Related
IF Formula That References A Cell And Returns A Different Result Dependant On The Number In The Cell Being Referenced
I'm trying to do a formula that references a cell and returns a different result dependant on the number in the cell being referenced.

For example I've said if A1 has a 3 in it then put the word TEST as the result, plus if it has a 4 put the word RESULT.

What I wrote as my formula is as follows-

=IF(A1=3,"TEST")+IF(A1=4,"RESULT")

It works fine when I only use one result but goes wrong when I add two. If I change the words I want to show to numbers it comes up fine but with words it just returns a Value error.

View Replies!   View Related
Formula To Add A Number To A Cell
I need a formula to add the number 1 into cell J9 when cell d9 is no longer blank.
I'm sure it's really easy- but I can't figure it out.

View Replies!   View Related
Add Cell Number To End Of Corresponding Formula
I have a monthly report on an excel spreadsheet that I must sum two columns from the previous month for every row in the sheet. I wish to take the value from column B and add to the end of the formula in column A. For instance my column A would contain the following: "=1200+6595+2599+275"

Column B would be a single number, i.e. "3200"

I want to be able to click a button and get "=1200+6595+2599+275+3200" in column A and place a "0" in column B for every row on the sheet. I have a pretty good understanding of VBA, but I am still learning the Excel object model.

View Replies!   View Related
Writing A Number After The Formula For A Cell
I have a cell in which I use the following formula:

View Replies!   View Related
Formula - Number In One Cell And None In The Other 4 Cells
I have 5 columns...I would like a formula to say if number in one cell and none in the other 4 cells to say "yes" otherwise say "no"

View Replies!   View Related
Sum(if Formula) Counts The Number Of Cell And Add
I have an array formula which reads:

{=SUM(IF(Female2!$A$2:$A$5000=$A403,IF(Female2!$C$2:$C$5000=C$402,IF(Female2!$1:$1=C$401,1,0))))}

However this formula only counts the number of cells (returns 96 for 96 cells) rather than adding the numbers in those cells to come to a total of 34.

View Replies!   View Related
Cell Value (number To Change If I Put A Formula In)
I have a cell containing a mixed text and number value e.g wk16 and would only like the number to change if I put a formula in.

For example, if i change my master cell A1 to wk15, I would like A2 to automatically change to wk18 or wk12 etc depending on the the formula

Every time I try = A1+3 I get #VALUE! appear in the cell.

I cannot change the cell so it contains a number as I am using Lookup functions.

View Replies!   View Related
Use Row Number In Cell For Reference Formula
I have five workbooks, one for each week of the month, and in a cell M9 in workbooks 1 to 5 I reference the value of a cell in another workbook called counter.xls.
The cell I need to reference changes each week by one row.

At the start of a month I need to have a macro that will go and find the first empty ...

View Replies!   View Related
Use Cell Number In Formula Row Reference
In cell A2, I have the number 10. In cell G10 of a different sheet, I have a number I want in a third location. Is there a way to do something in the third cell like =G(A2) so that the value of cell A2 is entered into the formula, referencing the value of G10 in the third cell?

View Replies!   View Related
Use Row Number Stored In Cell As Formula Row Reference
Column A contains numeric values that refer to a row number in column B. I need the value in column B to be outputted in column C. eg. if the value in Row 1 Column A = 55, the value in row 55 column B will be outputted in column C

View Replies!   View Related
Use TextBox Number In Cell Formula Added By Code
I'm having trouble getting my random number generator functions to use my variables that are defined by text box inputs. I can mouse over the variables in the code and they have the correct values, with the excpetion of where they are listed in the functions. I'm sure I'm missing something simple, thanks in advance for any help!

Private Sub cmdPopulate_Click()
StdDev = txtStdDev.Value
RandomNum = txtRandomNum.Value
Mean = txtMean.Value
lambda = txtLambda.Value
OriginCell = txtOriginCell.Value
If cmbDistributions.Value = "Normal" Then .................


View Replies!   View Related
Fill Down But Have Column Letter In Formula Change And Not Cell Number
i want to fill down a column and instead of my formula changing from A6 to A7 i want it to change to B6.

View Replies!   View Related
Stop Formula Changing Cell Reference But Change Sheet Number When Dragged?
need to do to the below code so that when i drag the formula down it changes the sheet number....sheet1, sheet2, sheet3 and so on but keeps the cell reference the same?

View Replies!   View Related
Reference Cell & Add Amount If Positive & Subtract Amount If Negative
Im trying to set up an active running inventory sheet where: (A)the progressive daily sheet cells reference back to the corresponding master sheet cells fluctuating the master values, (B) the same progressive daily sheet cells reference back to a cummulative totals-cell based on whether I added or subtracted inventory. I want to make a copy of the blank "sheet 2" with all of the formulas and move it to the end of the workbook each day and enter new values which will reference back to the master sheet so that I can click on a date sheet and see an individual day's values or click on the master sheet to see the fluctuating inventory on-hand and the cummulative +/- totals of all days combined. I've got a couple hundred individual cells to reference. I've tried and tried but I can't make it work. Heres what I need to do:

I need to reference individual cells from "sheet 2,3,etc" back to a corresponding cell in a master sheet. But I need the values in each cell in "sheet 2,3,ETC" to increase or decrease the corresponding cell values in the master sheet. For example: If the value in the master sheet B5 is 200. Then in sheet 2, I enter +50 in B5, I need the master sheet cell B5 to increase by 50 to 250. I also need a way to decrease the cell value in the master sheet B5 if I enter a negative value -50 in sheet 2 B5. I also want to know if I can reference the same cell values entered in "sheet 2,3,etc cell B5" back to totals columns C5 for adding inventory or D5 for subtracting inventory in the master sheet where the master totals columns would reflect cummulative totals added or subtracted. For example: if the value in sheet 2 B5 is +50, then the value in Master sheet C5 would add 50 to a progressive total. But if the value in sheet 2 B5 is -50 then the value in master sheet D5 would add -50 to a progressive total.

View Replies!   View Related
Formula Finding Number In Range To Display Another Number
Designated Cell = 7

1 10 .034
15 25 .072
35 45 .089

Output Cell = ???

I am trying to find a formula for the output cell. Suppose the designated cell = 7 due to formulas above it. So that number is always given but can change. I then need a formula for the ouput cell that says if the designated cell is greater than or equal to 1, and less than 10, then the output cell should equal .034. So suppose the designated cell = 18.2. Then I would want the output cell to be .072 since it is greater than or equal to 15, and less than 25. The template I am using has 23 rows of numbers like above. I didn't know how to do it for 23 rows though. If/Then doesn't work because it is 23 statements long (well over the seven limit) and the vlookup only works when the cell is equal to a number and not a range.

View Replies!   View Related
Multiply Every Integer Less Than The Number In Cell A1 And Greater Than Zero By The Number Cell In A2..
Cell A1 = 3
Cell A2 = 4

Is there a formula to calculate
(3*4)+(2*4)+(1*4)

I need to multiply every integer less than the number in cell A1 and greater than zero by the number cell in A2. I was thinking factorial, but that's not it... Can't remember from my math days.

View Replies!   View Related
Add And Subtract Time
How do I add and subtract hours minutes and seconds?

Im writing a program to find when the sun is directly overhead. Im doing this so that I can find the true north/south line. In the example on my program, at the town of Farmington, a plumb bob will cast a shadow on the north/south line at 11:51:39 on June 16

View Replies!   View Related
Add Or Subtract From Total
CELL A1=45

I want CELL A2 to be a blank cell which people can enter a number in that will decrease the value of A1 and once that value is entered, it would return to a blank cell. CELL A3 would be used in the same fashion except to increase the value of A1

what would a formula for this look like?

View Replies!   View Related
Subtract Dates D:hh:mm
Seems that when I subtract a future date from NOW() and format the cell d:hh:mm that the result is 1 day off. So if I subtract NOW() (today is 10/24) from 10/25/08 it returns a 1 for the d when I would expect it to be zero.

View Replies!   View Related
Subtract From Inventory
Firstly i am running Excel 2003 (at work)

Now my problem is that i have been asked to make a spreadsheet about Printer and Fax Cartridges (Zzzzz) but i do not know how to do the sum.

this is how my Spreadsheet looks like this (cartidge amount etc all on top line of spreadsheet)
(Hp45 etc all down left hand side) ...

View Replies!   View Related
Subtract But With Positive Sum
Im working on a time schedule form for my work. It all works good but it have one little error.

Lets say it looks like this
cell a1 has start time 22:00 and a2 has a end time 07:00. i know that i can switch the cells in the formula =sum((a1-a2)*24). like this ill get a negativ answer and that f.cks up the totalt becuse of the negativ answer i get.

is there a way to get 7:00 - 22:00 and 22:00 - 7:00 to calculate as positiv with one formula?

View Replies!   View Related
Subtract The Time
I need to be able to determine a departure time based on: Appointment - Transit time - 1 hour buffer......Clear as mud?

I tried using =SUM(M2-N2)-1, but being a noob, it's not working and I am lost, yes I admit it, I'm lost...

I do have all the cells format set [h]:mm


View Replies!   View Related
Subtract The Dates.
I have 2 cells in a row that are times, it has been a while since I did any work in excel. I want to take the first cell as start Time, the second cell is end time and I need to subtract them and put the total in a cell called Hours. What is the correct format to use and how would I do the subtraction.

Generally start time will be AM and End Time will be PM.

View Replies!   View Related
If? Vlookup? (take The Value And Subtract It)
Cell D10 to be a formula that; Looks at Cells E13:E38 and if in this range the text "Sick" appears looks at the adjacent cell H13:H38 (which has a numeric value). It will then take that value and subtract it from D8.

I will have to do this for 2 other text strings as well, Vacation and Holiday.

View Replies!   View Related
Subtract Dates
I have a column with start date and another next to it with end date. I now want a third column that gives the number of days alloted. I tried

=G6-F6 and that didn't work. What should I do?

View Replies!   View Related
Multiply Then Subtract Value
I have 3 columns. A B and C. In column C I want to input the answer to a formula into each cell using data from cells in their respective rows,

For. e.g.

Cx= Ax- (Bx X 0.8).

I want to be able to input this formula somewhere that will automatically fill out the cells in column C.

Column C is 20 cells long so x would range from 1 to 20.

View Replies!   View Related
Subtract Month VBA
I want to return the previous month in long text format and then use it as part of a file name. when i run the below the subtraction takes one day away from the current date and the msgbox displays "January". I want to return "March"

Sub test
Dim MyMonth
Dim TradesMonth
MyMonth = Month(Date) - 1
TradesMonth = Format(MyMonth, "mmmm")
msgbox TradesMonth
End Sub

View Replies!   View Related
Subtract/Take X Months Off Date
A1 contains an entered date (4/18/08). B1 contains an entered number representing months (6). I want C1 to subtract 6 months from 4/18/08 and then show the rounded down date of 10/1/07.

View Replies!   View Related
Subtract Milliseconds Or Seconds
I have a cell that has data formatted in this style:

0:00:08:412

h:mm:ss:ms

I was wondering how I might go about writing a formula that would subtract say 2 seconds, or 400ms from that value.

View Replies!   View Related
Subtract Date With No Year
I am looking for a way to count the number of Days after Christmas each year.

For example today is the 1st October hence it is easy to work out the number of days since last Christmas as being =Today()-25/12/2006

How do I have a reoccuring formula that is Today-Christmas each year without having to enter the year of last Christmas so that for example as at 26/12/2007 the answer will be 1 and so it will also be on the 26/12/2008?


View Replies!   View Related
Subtract X Amount Every Y Years
I am building an investing strategy model and am looking for a fomula or combination of formulae that would subtract an amount (lets say a 100) every so many years (lets say 10). Data is set up horizontaly, i want to be able to set how much will be subtracted and how often in a "control panel" next to other inputs and variables. I am not proficient in Macros and most often have trouble with them so if its possible to solve this without using any that would be great.

View Replies!   View Related
Subtract Date And Time
Is there a way to subract date and time? For example if in cell A1 you have 05/20/09 8:00 am. and in B1 you have 5/21/09 16:00. You want to know the time in between.

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved