Limiting Cells to Specific value

Options
DWoodside
DWoodside
in Modeling

Is there a way to limit the value of a cell to a specific range, say between 0-100%. The end desire is for anything input that results to a total exceeding 100% to cause an error or a message for the end user.

Answers

  • rob_marshall
    rob_marshall
    Options

    @DWoodside

    Short for that cell, no, but you could create another line item having formula "if line item > 100 then display a message (which should be list formatted and not Text). Or, you can create a list of numbers 1-100 and have it as a dropdown (list formatted).

Categories