|First, a posting tip: |
When posting in a Help forum such as this, please try to use a Subject Line that give us some details about your question. If everyone used a generic Subject Line such as "I Need Help With An Excel Formula" we wouldn't be able to tell one question from another and the Archives would essentially be useless.
I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.
As for your question...
"I want to take the number in cell c4 and divide it by the number 8 and then multiply it by 26. I have put the number 8 and the number 26 in a cell and I am typing the following formula:
Other than C4, you haven't told us what cells you have put the other numbers in or where you entered the formula. The formula you have posted is valid, although the parentheses are not needed because the order of operations will proceed from left to right.
A1 contains =C4/C33*C34
C4 contains 100
C33 contains 8
C34 contains 26
A1 should display 325.
If you will always be dividing by 8 and multiplying by 26, you can shorten the formula to:
re: "Also, how do i then make the formula keep C33 and C34 the same in every column?"
Using an Absolute Reference will "lock" the Column and/or Row when you drag the formula. A $ is used for Absolute References. A $ before the Column letter locks the Column, a $ before the Row number locks the Row. You can mix and match as required.
There are a ton of sites available via Google that will explain Relative vs. Absolute References. Check them out!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03