up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
feedback

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

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

1 Answer

up vote 3 down vote

What's the matter with using

=B8 * (1 + $B$19)

?

link|improve this answer
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
feedback

Your Answer

 
or
required, but never shown
discard