I have a column with prices listed (from top to bottom)
I want to add $5.00 to the prices in that column, without having to do it individually
Is there a way I can add automatically add $5 to each price on that column
the easiest way i know of doing it is:
use the next column, and add the formula (if items in column A, then enter formula’s into column B)A1:A200+$5 then just hide column A
or enter the amount to add in a separate cell then (say B2)A1:A200+$B$2 the $ makes the link absoute (stays B2 instead of going down the B column) i think thats right, but i havent used excel since excel 97, so wait for more replies
Sorry, I have no idea what your talking about; can you re-state that in a step by step process
right if your column of prices are i column A, enter this formula into column BA1:A200+$C$2then enter the amount you wish to add into column C ($5)
i think this will work, but as i said i’m well out of date in using excel, i last used excel when it was excel 97, and my memory is getting worse - it’s an age thing
P.S. yes i altered formula - see, memory