Question We have an Excel pros on here - need help

[SaltyUser199]

To reference a number in a cell, you would generally simply say something like: =B63

That spits the value out of what is in cell B63. Nice and simple.

But I want to change the "63" reference to a different number, which number I can change in another cell. So let's say I plugged "30" in cell Z1. Using the above methodology, I would think I would put in something like =B(63-Z1) and have it spit out the value in cell B33. But that does not work.

Anyone know how I would do something like that?

 

[USAFRet]

=INDIRECT( )

Here, the values are in cells B20 and B22.
Variables in F1 and F2
Result in B10

The formula in B10 is =INDIRECT(F1&F2)

Change the value of F2 to 20, and B10 changes to 400

 

[Aeacus]

If you want to add two cell values together, the target cell (where you want to have the result) must include the command/formula.

For example; target cell C87 + target cell C86 formula would be;

=SUM(C87+C86)

And if i put that formula to e.g cell B55, the B55 cell displays the result of adding both cell values together.

Subtracting would be:

=SUM(C87-C86)

 

[SaltyUser199]

=INDIRECT( )

Here, the values are in cells B20 and B22.
Variables in F1 and F2
Result in B10

The formula in B10 is =INDIRECT(F1&F2)

Change the value of F2 to 20, and B10 changes to 400

USAFRet, you are awesome, thanks so much. That is definitely helpful. I might have other questions, given that I may have not asked the correct question, but let me work on my spreadsheet and I'll follow up if I didn't quite get the question right on my end. Thanks so much!!!

 

[SaltyUser199]

If you want to add two cell values together, the target cell (where you want to have the result) must include the command/formula.

For example; target cell C87 + target cell C86 formula would be;

=SUM(C87+C86)

And if i put that formula to e.g cell B55, the B55 cell displays the result of adding both cell values together.

Subtracting would be:

=SUM(C87-C86)

Thanks Aeacus, I think USAFRet covered it, but I sure appreciate the help!!!

 

[USAFRet]

USAFRet, you are awesome, thanks so much. That is definitely helpful. I might have other questions, given that I may have not asked the correct question, but let me work on my spreadsheet and I'll follow up if I didn't quite get the question right on my end. Thanks so much!!!

No prob...😉