Hi,
i have item Codes in ColumnA(A2:A500) and values in columnC (C2:C500)
i need to multiply whole range in C with given number inputed by user.
Additional to this, for few specified items (code: 123, 321, 231), the sign - or + needs to be converted -to+ or +to-
(i am thinking of going with the form of somekind)
Also, i need to format ColumnD with Text.

Can this be done?
thx in advance