|
| Posted by: TacoJohn
- [576191613] Fri, Aug 13, 2004, 19:37
I want to do something a little different w/ Excel, but I think it can be done (i hope...)
Okay, I have a value in A1, i want to subtract the value x rows down from it and put that in B1.
The x value is stored in another cell.
So if A1 is 5, E1 is 3, and the x value is 4...
It takes A1 minus the number 4 rows down (E1) and returns 2.
Is that possible to do with a simple formula that I can type in? |
| | | 1 | Mike D
Sustainer
ID: 041831612
Fri, Aug 13, 2004, 21:10
|
Honestly not sure what you mean. Almost sounds like you want a formula in cell B1 that would equal A1 - E1. Is that correct??? That is pretty easy, so I may not be understanding you.
|
|
| | | 2 | biliruben
ID: 441182916
Fri, Aug 13, 2004, 21:18
|
I think the value of E1 differs by row.
Sometimes it is 4 down, sometimes 3 down, sometimes 8 down. Right?
|
|
| | | 3 | Guru
ID: 330592710
Fri, Aug 13, 2004, 23:19
|
4 rows down would be A5, not E1.
You could use the INDEX function.
=A1-INDEX(range, x)
where range would be the range of cells (either a row or column), and x would be the value (or cell reference)
|
|
| | | 4 | RecycledSpinalFluid
Dude
ID: 204401122
Fri, Aug 13, 2004, 23:48
|
Column A = Values
Column B = Row (Downward) Offset
Column C = Column (Left Right) Offset
Column D = Resultant
D1 = "=A1 - OFFSET(A1,B1,C1)"
|
|
| | | 5 | TacoJohn
ID: 576191613
Sat, Aug 14, 2004, 04:59
|
RSF, you little fiend, you!
Sorry about being SUPER vague in my explanation (and mixing up rows and columns).
Anyway, it took me a minute to figure out how that formula works but it's dead-on what I was after.
Thank you!
|
|
|
|