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