Bob
As you said the other way round, the result is 156%, but it is easier
to work below the 100%.
the objective is to measure the efficiency against my request, sending
the supplier more or less amount.
in the example that I gave the result it should be 64%, if the supplier
sends less amount than the request " C5=15000; D5=13000 " I obtain the
result in E5 of 115%. when actually the efficiency against my request
was 85%.
being B1=average column "E" if I don't obtain the result of 85% in E5,
I am distorting the result.
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