Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel General
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Alex Plantema, post: 7426280"] Create a table, in e.g. G2:I12 with contents: -5 3 0 -4 -4 -4 -3 2 -5 -2 1 -3 -1 1 -2 0 1 0 1 1 -1 2 1 -1 3 2 -2 4 4 4 5 1 1 and use =IF(B3=D3;VLOOKUP(E2;G$2:H$12;2);VLOOKUP(E2;G$2:I$12;3)) in E3. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel General
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O
Top
