Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |