shawn99michaels
New Member
- Joined
- May 16, 2007
- Messages
- 38
hi All,
I was wondering if any of the excel gurus might know a trick whereby values could be limited to max and min.
My current formula is a/b and sometimes it gives me figures of 384% and I want it to be limited to 100% or 0%.
is there anyway using max and min this can be corrected ?
thanks,
Shawn
I was wondering if any of the excel gurus might know a trick whereby values could be limited to max and min.
My current formula is a/b and sometimes it gives me figures of 384% and I want it to be limited to 100% or 0%.
is there anyway using max and min this can be corrected ?
thanks,
Shawn