Good afternoon Ellie

You could achive this using a "helper" column. Say A=256 / 356, B=
your quantity and your first row is row 1. In column C use the
formula:

=IF(A1=256,B1,B1*-1)

and copy it all the way down.

Once done, you could use Copy-Paste As function to convert the formula
back into "proper" numbers.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=401947