Financial Modeling
Ask your modeling questions here! Feel free to copy/paste specific sections from filings as appropriate.
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
1) How do I write a Vlookup formula to convert text input to numberica score with example as follows:
High 10
Medium 5
Low 3
2) Per Hamilton Lin, we should avoid Nestedif statement at all cost. In the case above, is it easier to do a Nestedif statement, simple and straightforward?
'=IF($A2="HIGH",10,IF($A3="MEDIUM",5,IF($A4="LOW",3,0)))
Please correct me if I am wrong.
Many thanks! Read More