Hi Folks
I'm running some calculations for the email turnaround and I would like to compare (probably divide) 2 figures (average daily emails Processed and email Backlog at period end).
The results of this calculation need to be limited at a maximum value of 105% and a minimum value of 0.
Is anyone aware of a function within excel that will allow me to accomplish this?
Hoping....
Thanks
Bookmarks