View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Formula or Function?

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