Possible to multiply all cells in a column by a value in a specified cell?



Newbie here so this might be a silly question. I have a sheet with product numbers and prices. Recently we had a price increase across all of our products. I was hoping to be able to take all the values in my price column and multiply them by 6% (the price increase). I have the 6% hanging out in a specified cell. Is it possible to multiply all the cells in my price column by the 6% cell I have?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!