Is it possible to set a maximum value that will be displayed in a cell, even if the forumla within the cell surpasses this maximum value?
E.g. I have a formula that gives me numbers above 100 sometimes and I can't help the fact that it does, but is there a way to 'cap' the cell so that any...