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

I assume: 1. You put the formula in some cell on its own.

2. Put 8 in C33

3. Put 26 in C34

4. Put your chosen number in C4

Worked just fine for me. My chosen number was 16 which I put in C4 and this produced 52 in the cell containing the formula.

Alwayspop back and let us know the outcome - thanks

message edited by Derek

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)*c34Other 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*C34

C4 contains 100

C33 contains 8

C34 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*26

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.

=C4/$C$33*$C$34

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

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History