I have a column of currency formatted cells (C8:C15) and a markup rate of 15% which is entered into B19. I want to have the markup rate applied to C8:C15. Starting with C8 I entered the formula =B8 + $B$19 but this merely gave me $24.15.

I know I can write *1.15 to get the correct result but this is for a school assignment and the teacher wants me to use "absolute cell referencing". Basically I have to refer to the cell C8 as the formula, not just write *1.15.

Here's a picture with the project that might help explain:

enter image description here

migrated from stackoverflow.com Oct 9 '11 at 16:11

This question came from our site for professional and enthusiast programmers.


What's the matter with using

=B8 * (1 + $B$19)


  • 1
    Nothing! Nothing at all! Thank you. :) – Mein Luck Oct 9 '11 at 3:18
  • Feel free to accept this answer if your problem is solved. – Matt Ball Oct 9 '11 at 3:49
  • 2
    Accept an answer by clicking the arrow that appears on the upper left of the answer. :) – Issun Oct 9 '11 at 12:23

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.