Forum Discussion
Row dependent function
Want to form a function that is row dependent. For given columns E & G, the following functions appear in cells G7, G8 & G9 : G7=G6-E7 G8=G7-E8 G9=G8-E9 Form a general function of these equation...
HansVogelaar Got it, instantaneous and simultaneous. Thank you for your assistance. As an aside, is this formula and procedure to be found somewhere else within Excel as a standard formula and procedure? Or did you produce it in order to answer my enquiry? If necessary, I would be interested to learn how to produce other non-standard formulae and procedures any time in the future.
The formula itself is specific for your request.
Ctrl+Enter to enter a formula in all cells of the selected range is a standard Excel shortcut. You can find it in (for example) Keyboard shortcuts in Excel
By the way, this would also have worked:
- Select G7:G100
- Enter the formula =G6-E7
- Press Ctrl+Enter
HansVogelaar Thank you again for the info. Useful to know for future reference.