The following worksheet shows Product Name ,Unit cost in columns A and B. Write steps to compute selling price in column C when profit percentage is entered in cell D9. (Excel Problems)
The following worksheet shows Product Name ,Unit cost in columns A and B. Write steps to compute selling price in column C when profit percentage is entered in cell D9.
To calculate selling price in column C,
Enter the formula
=B1+B1*$D$9 in cell C2 and then press enter key,
using the fill handle of cell C2, copy the formula to cells C3 :C6 by dragging the fill handle up to cell C6 .
0 comments:
Post a Comment