Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtracting numbers
I know this is simple, but I'm having trouble getting it right.
two columns of numbers ... the first column is for figures for 2004 and the second is for figures for 2005. What I want to do is show the difference in a third column of increase or decrease. example: 2004 2005 diff 3.00 0 -3 2.00 1.00 -1 3.00 5.00 2 Can any help? (Thanks!) |
#2
|
|||
|
|||
Shoot .. .I forgot a key bit of information ... sometimes the number in
column two are negatives and sometimes column one negatives ... "Annette" wrote in message ... I know this is simple, but I'm having trouble getting it right. two columns of numbers ... the first column is for figures for 2004 and the second is for figures for 2005. What I want to do is show the difference in a third column of increase or decrease. example: 2004 2005 diff 3.00 0 -3 2.00 1.00 -1 3.00 5.00 2 Can any help? (Thanks!) |
#3
|
|||
|
|||
Try...
C2, copied down: =B2-A2 Hope this helps! In article , "Annette" wrote: I know this is simple, but I'm having trouble getting it right. two columns of numbers ... the first column is for figures for 2004 and the second is for figures for 2005. What I want to do is show the difference in a third column of increase or decrease. example: 2004 2005 diff 3.00 0 -3 2.00 1.00 -1 3.00 5.00 2 Can any help? (Thanks!) |
#4
|
|||
|
|||
Put this in C1 and copy down.............
=IF(B1A1,B1-A1,(A1-B1)*-1) Vaya con Dios, Chuck, CABGx3 "Annette" wrote in message ... I know this is simple, but I'm having trouble getting it right. two columns of numbers ... the first column is for figures for 2004 and the second is for figures for 2005. What I want to do is show the difference in a third column of increase or decrease. example: 2004 2005 diff 3.00 0 -3 2.00 1.00 -1 3.00 5.00 2 Can any help? (Thanks!) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Subtracting and multiplying tax numbers witht he IF function | Excel Discussion (Misc queries) | |||
Subtracting Negative Numbers | Excel Worksheet Functions |