I HAVE A PRICE SHEET WITH 1500 NET PRICES IN COLUMN "C". I WANT TO USE A 2X MULTIPLIER TO MAKE A LIST PRICE SHEET WITHOUT HAVING TO USE:"=PRODUCT(NET PRICE)*2" REPEATEDLY FOR EACH PRICE CHANGE. WHAT FORMULA CAN I USE TO DOUBLE ALL THE NET PRICES IN COLUMN 'C" WITH ONE ENTRY?
THANKS,
CHUCK
THANKS,
CHUCK