Surely the formula should be =D4/C4. Of course if you receive more than
requested, you get more than 100%, but that seems right to me.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Dipwind" wrote in
message ...
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