Converting % to Positive Number

[jarett]

I sometimes get negative values with this formula and it is affecting my average, so how could I convert any negative numbers to a positive percentage within this formula? Or do I need to create another column to accomplish this. Ex. if I the formula produced -25%, I would want to display 25%.

=IF([@[Qty on Shelf]]="","",([@[Updated QTY]]-[@QuantityOnHand])/[@QuantityOnHand])

IM_WH_COUNT.xlsx
	A	B	C	D	E	F	G	H
2	ItemCode	ItemCodeDesc	WarehouseCode	QuantityOnHand	Qty on Shelf	WIP Additions	Updated QTY	Percent Difference
3	08-0003188	NO HOLES-31-1/2 X 500 .005 WHT	000	0			0
4	08-0007208	120 in.SPACING-31-1/2 x 500' .	000	3	2	1	3	0%
5	08-0007208	120 in.SPACING-31-1/2 x 500' .	003	0			0
6	08-0007209	34 in.SPACING-31-1/2 x 500' .0	000	8	2	4	6	-25%
7	08-0007211	60 in.SPACING-31-1/2 x 500' .0	000	0			0
8	08-0007212	60 in. SPACING-19 X 500' .005	000	4	5	1	6	50%
IM_WH_COUNT

Cell Formulas
Range	Formula
G3:G8	G3	=[@[Qty on Shelf]]+[@[WIP Additions]]
H3:H8	H3	=IF([@[Qty on Shelf]]="","",([@[Updated QTY]]-[@QuantityOnHand])/[@QuantityOnHand])

 

[Joe4]

You can convert any negative value to a positive one by using the ABS function, i.e.

=IF([@[Qty on Shelf]]="","",ABS(([@[Updated QTY]]-[@QuantityOnHand])/[@QuantityOnHand]))

 

[jarett]

You can convert any negative value to a positive one by using the ABS function, i.e.

=IF([@[Qty on Shelf]]="","",ABS(([@[Updated QTY]]-[@QuantityOnHand])/[@QuantityOnHand]))

so cool!