# Solved Excel Division & Multiplication Formula Help

February 22, 2015 at 13:01:34
Specs: Windows 7
 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:=(c4/c33)*c34 nothing is happening. what am I forgetting please?Also, how do i then make the formula keep C33 and C34 the same in every column?message edited by Christinamoh

See More: Excel Division & Multiplication Formula Help

#1
February 22, 2015 at 13:32:56
 I assume:1. You put the formula in some cell on its own.2. Put 8 in C33 3. Put 26 in C344. Put your chosen number in C4Worked just fine for me. My chosen number was 16 which I put in C4 and this produced 52 in the cell containing the formula.Always pop back and let us know the outcome - thanksmessage edited by Derek

Report •

#2
February 23, 2015 at 06:43:30
 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:=(c4/c33)*c34 "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.Assuming:A1 contains =C4/C33*C34C4 contains 100C33 contains 8C34 contains 26A1 should display 325.If you will always be dividing by 8 and multiplying by 26, you can shorten the formula to:=C4/8*26re: "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.=C4/\$C\$33*\$C\$34There are a ton of sites available via Google that will explain Relative vs. Absolute References. Check them out!message edited by DerbyDad03

Report •
Related Solutions