ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   multiply negative (https://www.excelbanter.com/excel-discussion-misc-queries/208962-multiply-negative.html)

amaries

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?

Peo Sjoblom[_2_]

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?




Roger Govier[_3_]

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?




All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com