We have an Excel pros on here - need assistance.
We have an Excel pros on here - need assistance.
To reference a number in a cell, you usually just type something like: =B63
That extracts the value from what’s in cell B63. Easy and straightforward.
But I need to modify the "63" part so it uses a different number from another cell. For example, if I set the value in Z1 to 30, I’d think of using =B(63-Z1) to get B33. That doesn’t seem to work.
Anyone know how to adjust that?
When combining two cell values, the desired output cell should contain the specified command or formula. For instance, adding C87 and C86 would look like =SUM(C87+C86), and applying this to B55 shows the sum in that location. Similarly, subtracting would be represented as =SUM(C87-C86).