If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




How to format whole column negative value, Excel
I want to make a whole column negative currency value so that the sum of
A+B=Difference. This is to remove the entries in B from the customerâ€™s responsibility. Or should one just use the formula, =AB, and format the appearance of the remainder column? Am I correct: that Excel does not have a function for DIFFerence or SUBTraction? 
Ads 
#2




How to format whole column negative value, Excel
Please clarity this. We want to help, but I for one and confused
best wishes  Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "PES" > wrote in message ... >I want to make a whole column negative currency value so that the sum of > A+B=Difference. This is to remove the entries in B from the customer's > responsibility. > Or should one just use the formula, =AB, and format the appearance of the > remainder column? > Am I correct: that Excel does not have a function for DIFFerence or > SUBTraction? > > 
#3




How to format whole column negative value, Excel
Do you mean that you just want the difference between A and B and return that
as a positive number irrespective of whether A or B is the larger value? If so then you can use the following: =ABS(A2B2)  Regards, OssieMac "PES" wrote: > I want to make a whole column negative currency value so that the sum of > A+B=Difference. This is to remove the entries in B from the customerâ€™s > responsibility. > Or should one just use the formula, =AB, and format the appearance of the > remainder column? > Am I correct: that Excel does not have a function for DIFFerence or > SUBTraction? > > 
#4




How to format whole column negative value, Excel
Apply this formula in Column C1 '=B1' and copy that to the entire column C
Copy entire Column B. Right Click PasteSpecial>Values to column D. Delete column B and column C If this post helps click Yes  Jacob Skaria "PES" wrote: > I want to make a whole column negative currency value so that the sum of > A+B=Difference. This is to remove the entries in B from the customerâ€™s > responsibility. > Or should one just use the formula, =AB, and format the appearance of the > remainder column? > Am I correct: that Excel does not have a function for DIFFerence or > SUBTraction? > > 
#5




How to format whole column negative value, Excel
Hi,
1. there is no SUBTRACT or DIFFERENCE function in Excel 2. I would use =A1B1 and coping it down 3. However, you can convert all the entries in column B to negatives as follows. In a blank cell enter 1. Select that cell and copy it. Then select the numbers in column B and choose Edit, Paste Special, Multiply.  If this helps, please click the Yes button. Cheers, Shane Devenshire "PES" wrote: > I want to make a whole column negative currency value so that the sum of > A+B=Difference. This is to remove the entries in B from the customerâ€™s > responsibility. > Or should one just use the formula, =AB, and format the appearance of the > remainder column? > Am I correct: that Excel does not have a function for DIFFerence or > SUBTraction? > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Excel negative number format options don't include brackets. Why?  Barrybloke  Excel Discussion (Misc queries)  1  July 8th 07 08:40 PM 
How do I format a column to show a negative percentage in red?  swanny  Excel Discussion (Misc queries)  1  May 2nd 07 04:38 PM 
Get Excel to accept negative values using timeformat  Marcus AhlbÃ¤ck  Excel Discussion (Misc queries)  1  November 9th 05 12:19 PM 
How do i get excel to format a cell for a negative result.  Cisco  Excel Discussion (Misc queries)  4  July 21st 05 08:40 AM 
How do I format a column to automatically make it a negative numbe  Kathy  Excel Worksheet Functions  1  January 25th 05 04:15 AM 