Any Microsoft excel guru out there?

[rayden001]

---

Members do not see this ad.

How do I type a formula into excel where my answer depends on the output directly above it?

Thanks

 

[BiochemGuy]

Click on the cell, type an equal sign "=", then any mathematical operation you want. For example, =(A1+A2)/A3

Also, google may help.

 

[rayden001]

Click on the cell, type an equal sign "=", then any mathematical operation you want. For example, =(A1+A2)/A3

Also, google may help.

Thanks for the response. But I actually referring to something a little more complex than just mere formula entry.

Perhaps an example might help convey my message.

Say I have a value in A1, A2 depends on A1, A3 depends on A2, A4 depends on A3 and so on...

What do I need to include in the formula so that excel does this automatically?

I can't use "$" since that is for absolute reference.

 

[Bacchus]

Use the $ in front of the letter, not the number. It restricts to that letter column but not the number.

 

[tca]

The dollar sign restricts the column, row or both depending on where you put it.


For example:
1) $A1
2) A$1
3) $A$1

All do different things. 1 keeps the 'A' unchanging when you drag the formula down, 2 keeps '1' unchanging and 3 keeps the exact cell reference unchanging.

 

[rayden001]

Thanks guys. I got it!

Boy, I really need to take a stats class😳

 

[unhappytnt]

This thread made me chuckle. I am working at an investment banking job for the summer so all my days are spent with data entry in Excel. I learned so many excel functions that I didn't know existed before. 😀