With 500 in cell A1 and 10 in cell B1
in a third cell put
=1-(B1/A1)
or directly
=1-(10/500)
format as percentage under formatcellsnumberpercentage
--
Regards,
Peo Sjoblom
(No private emails please)
"trev2283" wrote in
message ...
Hi all
This is my first post so be gentle with me!!
I'm new to excel and have just started to play around using formulas,
could someone tell how to calculate percentages using excel
Something simple like.........
If I had 500 deliveries a week and 10 were late that would equal 98% on
time deliveries
How would I put a formula in to an excel spreadsheet to calculate this
Thanks in advance for any help
Trev
--
trev2283
------------------------------------------------------------------------
trev2283's Profile:
http://www.excelforum.com/member.php...o&userid=28588
View this thread: http://www.excelforum.com/showthread...hreadid=482512