I am trying to measure a service efficiency .
Cell C4, requested amount.
Cell D4, received amount.
Cell E4 =C4/D4. with result in%
Cell B1 = average Column E.
This works, but when the value in D4 is smaller than C4, E4 returns
more than 100%. I intend that the difference for more or for less, be
presented in%.
how to do?
Thanks in advance
Joćo
--
Dipwind
------------------------------------------------------------------------
Dipwind's Profile:
http://www.excelforum.com/member.php...o&userid=36276
View this thread:
http://www.excelforum.com/showthread...hreadid=571037