Explore. Ask. Answer.

or Explore Discussions

Best Practice

Archives for May 2021

Discussion List

  • Using a nested IF to determine a range
    In Best Practice
    Here's a little tid-bit I just figured out today... You can use a nested IF statement to output ranges/cross sheet references that are to be evaluated. The particular use case that led to this was an INDEX/MATCH where we wanted to INDEX o…
    Paul Newcome Profile Photo Paul Newcome
    26 6
    26 views 6 comments Most recent by [email protected] Best Practice