Microsoft Excel Question?

Question

Hi all,

I'm not very familar with excel so perhaps someone can offer me advice.

How do you create a formula to auto calculate, example I need column H to automatically add 24% from column F

Thanks

Answer 1

Type =F1*1.24 and press enter. The result will be 24% higher than the amount in cell F1

Answer 2

Click the first cell in column H that will hold the new value. With this cell selected (H3, for example), click inside the formula field (has the fx) to the left of the field at the top of the Excel window. Then enter an equal sign (=). This lets Excel know you want to add a formula. Then an open parenth. Then click once on the cell in column F that you want to use for the calculation (F3, for example). Then type an asterisk, then 1.24, and a close parenth. Should look like this:
=(F3*1.24)
Press the Enter key and you should have the result.

That's it for the first cell. Now, for the rest of the cells in column H, look at that first cell that you clicked on. With that cell still selected, it should have a dark black border around it and a small black square in the lower right corner. Click this small black square/dot/whatever and drag it down the column for as far down as you have data. Cliick somewhere else, outside of that range of cells, and the same formula will be applied to those cells in column H.

Answer 3

Lemme guess, you're in a Computer Literacy class... maybe with the Art Institute??? Because whats funny is that's the EXACT question of this weeks first assignment. weird. "Week 3: Week 3 - W3: Assignment 1 Discussion Discussion Question 3 Compare Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. When should you use each of these applications? When can you use these applications interchangeably? Give examples and reasons to support your answer."

Answer 4

Type this into cell H2
=F2+(F2*24%)
Make sure the cell format is general too.

Then copy this formula to all the other cells in the H column.

Answer 5

For example
say Cell A contains numeric values
you want to put 24% of A in cell B

To do so

go to Cell B
type = (A1*24)/100
Copy the B1
Paste it in followng all B Cells (ie B1 .... Bn)

Please update me if it works.. :-)

Answer 6

See Enter the following falmula in desired cell and you will add 25% of cell H1

=SUM(H1+(H1*25)/100)



Thanks you.
ALI
Keep Going with Yahoo Answers

Answer 7

You take the cell name (e.g. F20) of the number you want as your base, and in the cell where you want your answer (e.g. H20), you write: +F20*1.24
It will increase the number in the "F" cell by 24%. If you only want to know what 24% is, you use: +F20*.24

Answer 8

in cell h1 enter the following:
=h1+.24*f1

Answer 9

I think you already have a formula in the H cell also. (Say your cell is H2)

Then whatever the formula you have in H2, first put them within brackets . for ex (sum(A2:C4:))

Then type the following formula (add) (F2*0.24)
Then your whole formula should be
=(sum(A2:C4:))+(F2*0.24)

Answer 10

In column F you write: =H3+(H3*24%) (if your column F is F3).