Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiply negative
Please forgive simplistic question but I am just about brain dead from lack
of sleep in the middle of physical inventory. I have a listing of balances of items and their standard costs. I have some negative balances/quantities on some items (don't ask) so I need to get a column that shows the Cost * Quantity. My negative quantities are coming in like 1.00- for negative 1. So I need to show for each item the quantity and its total value negative or positive. Item Qty Cost each Total Value A 24.64- $2.65 $-65.296 I am totally drasing a blank. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiply negative
Select the Qty column, do datatext to columns, click next twice and under
advanced make sure "Trailing minus for negative numbers" is checked, then click OK and finish. That should convert them to leading negatives then just use a regular multiplication like =B2*C2 where B2 is Qty and C2 cost -- Regards, Peo Sjoblom "amaries" wrote in message ... Please forgive simplistic question but I am just about brain dead from lack of sleep in the middle of physical inventory. I have a listing of balances of items and their standard costs. I have some negative balances/quantities on some items (don't ask) so I need to get a column that shows the Cost * Quantity. My negative quantities are coming in like 1.00- for negative 1. So I need to show for each item the quantity and its total value negative or positive. Item Qty Cost each Total Value A 24.64- $2.65 $-65.296 I am totally drasing a blank. Can anyone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiply negative
Hi
If I understand your question correctly, then =ABS(B2)*C2 -- Regards Roger Govier "amaries" wrote in message ... Please forgive simplistic question but I am just about brain dead from lack of sleep in the middle of physical inventory. I have a listing of balances of items and their standard costs. I have some negative balances/quantities on some items (don't ask) so I need to get a column that shows the Cost * Quantity. My negative quantities are coming in like 1.00- for negative 1. So I need to show for each item the quantity and its total value negative or positive. Item Qty Cost each Total Value A 24.64- $2.65 $-65.296 I am totally drasing a blank. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing color of negative bar when using Invert if negative | Charts and Charting in Excel | |||
multiply | Excel Discussion (Misc queries) | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions |