How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 30137
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I am trying to get the number in the D Column multiplied by

This answer was rated:

I am trying to get the number in the D Column multiplied by I5 in batch.... not sure how to do this.
Thank you for your question, my name is Richard.

Sorry I do not completely understand number in the D Column multiplied by I5 in batch, how do you mean in batch? and which column is showing this result (holding the formula)?

Thank you

Customer: replied 3 years ago.

sorry, sometimes I'm not very good at explaining myself. I want all the numbers in the C column (Retail) mulitplied by I5 to get the Cost.... I want to be able to do it for the entire column without changing the formula for each cell.

Its ok, where do you want this number displayed? in which column?

Customer: replied 3 years ago.

in Column D, the cost. I'm mulitplying the retail by I5 to get the cost.

Thanks, XXXXX XXXXX Row 1 put in

C3 = $I$5

And copy this into all Cells in Column D

Let me know if you have any difficulties please

Customer: replied 3 years ago.

for some reason I'm getting a false error

use this please


Richard and other Microsoft Office Specialists are ready to help you