Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Oct 9 '11 at 16:11

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

add comment

1 Answer

What's the matter with using

=B8 * (1 + $B$19)

?

share|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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.