Constant in formula

Solved/Closed
John - Dec 1, 2009 at 09:56 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Dec 2, 2009 at 06:08 AM
Hello,

I am trying to use a input cel in excell

1) On my excel sheet I have data on A1,A2,A3,A4,A5 containing the amount of ml ink being used.

2) on cell B1 I have the input of Priceper ml that I want the user to put in.

3) on C1 I have the formula of "=ROUNDDOWN(SUM(A1*B1),2)"

now if I drag C1 down to C5 I want in my formula A1 to count from A1 to A5 but I dont want B1 to count but be constant.

My problem is when I drag down from C1 to C5 that in my formula B1 also counts from B1 to B5 .

How can I have B1 as input and remain constant in the formula

1 response

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Dec 2, 2009 at 06:08 AM
Hello,
You have to put a $ between the B and 1 to fix the cell thus your formula become :
=ROUNDDOWN(SUM(A1*B$1),2)
Best regards
1