Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula help on a cell
Register Bank Cash Cumm Cash
Money Deposit Over (over short) (short) $704.89 $704.32 $-0.57 $0.57 $766.86 $769.44 $+2.58 $2.01 $563.71 $563.61 $-0.10 $1.91 $678.18 $677.86 $-0.32 $1.59 $875.26 $875.15 $-0.11 $1.48 How do I create the formula for the last column. Having troubles if the column before is a positive number to add, but is negative I have to subtract. Myrna -- Thank you |
#2
|
|||
|
|||
Don't know if excel has it (though it should) have you tried looking for an Absolute Value to use? -- bpat1434 ------------------------------------------------------------------------ bpat1434's Profile: http://www.excelforum.com/member.php...o&userid=16155 View this thread: http://www.excelforum.com/showthread...hreadid=276075 |
#3
|
|||
|
|||
Hi
have you entered the data with a preceding $ sign? or have you importe this data? -- Regards Frank Kabel Frankfurt, Germany Myrna wrote: Register Bank Cash Cumm Cash Money Deposit Over (over short) (short) $704.89 $704.32 $-0.57 $0.57 $766.86 $769.44 $+2.58 $2.01 $563.71 $563.61 $-0.10 $1.91 $678.18 $677.86 $-0.32 $1.59 $875.26 $875.15 $-0.11 $1.48 How do I create the formula for the last column. Having troubles if the column before is a positive number to add, but is negative I have to subtract. Myrna |
#4
|
|||
|
|||
No, you really don't have to subtract.
2 PLUS -1 equals 1 So, in D1 enter: =C1 And in D2 enter: =C2*(C2<"")+D1 And drag down to copy as needed. This will repeat the last calculation to any empty rows that do not have any figures entered yet. If you would prefer to see zeroes for these as yet not entered rows, try this formula in D2: =(C2<"")*(C2+D1) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Myrna" wrote in message ... Register Bank Cash Cumm Cash Money Deposit Over (over short) (short) $704.89 $704.32 $-0.57 $0.57 $766.86 $769.44 $+2.58 $2.01 $563.71 $563.61 $-0.10 $1.91 $678.18 $677.86 $-0.32 $1.59 $875.26 $875.15 $-0.11 $1.48 How do I create the formula for the last column. Having troubles if the column before is a positive number to add, but is negative I have to subtract. Myrna -- Thank you |
#5
|
|||
|
|||
Frank,
I have the cell property set on currency for the cell. I manually type in the data before the column for this calculation "Frank Kabel" wrote: Hi have you entered the data with a preceding $ sign? or have you importe this data? -- Regards Frank Kabel Frankfurt, Germany Myrna wrote: Register Bank Cash Cumm Cash Money Deposit Over (over short) (short) $704.89 $704.32 $-0.57 $0.57 $766.86 $769.44 $+2.58 $2.01 $563.71 $563.61 $-0.10 $1.91 $678.18 $677.86 $-0.32 $1.59 $875.26 $875.15 $-0.11 $1.48 How do I create the formula for the last column. Having troubles if the column before is a positive number to add, but is negative I have to subtract. Myrna |
#6
|
|||
|
|||
Myrna
Assuming you have =B2-A2 in Column C(copied down, of course) In D2 enter =C2 In D3 enter =D2+C3 and drag/copy down column D Gord Dibben Excel MVP On Sun, 7 Nov 2004 12:33:03 -0800, "Myrna" wrote: Register Bank Cash Cumm Cash Money Deposit Over (over short) (short) $704.89 $704.32 $-0.57 $0.57 $766.86 $769.44 $+2.58 $2.01 $563.71 $563.61 $-0.10 $1.91 $678.18 $677.86 $-0.32 $1.59 $875.26 $875.15 $-0.11 $1.48 How do I create the formula for the last column. Having troubles if the column before is a positive number to add, but is negative I have to subtract. Myrna |
#7
|
|||
|
|||
hi,
Assiming that the last column is D,In cell D1, you have shown $0.57 instead of -$0.57 K.S.Warrier "Gord Dibben" wrote: Myrna Assuming you have =B2-A2 in Column C(copied down, of course) In D2 enter =C2 In D3 enter =D2+C3 and drag/copy down column D Gord Dibben Excel MVP On Sun, 7 Nov 2004 12:33:03 -0800, "Myrna" wrote: Register Bank Cash Cumm Cash Money Deposit Over (over short) (short) $704.89 $704.32 $-0.57 $0.57 $766.86 $769.44 $+2.58 $2.01 $563.71 $563.61 $-0.10 $1.91 $678.18 $677.86 $-0.32 $1.59 $875.26 $875.15 $-0.11 $1.48 How do I create the formula for the last column. Having troubles if the column before is a positive number to add, but is negative I have to subtract. Myrna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions |