Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change. To simplify to process, use an absolute reference ...

Got confused on how to get this requirement in a single statement without using T-SQL. Check this solution even though it is not so elegant, but works great having said what the requirement looks.