Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from 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)


share|improve this answer
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
Accept an answer by clicking the arrow that appears on the upper left of the answer. :) – Issun Oct 9 '11 at 12:23

You must log in to answer this question.