I'm having difficulty coming up with an excel formula. I want to have numbers in a particular column come in between a low of 0 and a high of 99.
The thing is I don't know how to do it. It sounds simple enough but I'm still a beginner in this.
The problem arises when a sum comes up as a negative number (ex. -13). And I'm trying to keep it between 0 & 99.
I would appreciate the help.
The thing is I don't know how to do it. It sounds simple enough but I'm still a beginner in this.
The problem arises when a sum comes up as a negative number (ex. -13). And I'm trying to keep it between 0 & 99.
I would appreciate the help.