I think OP wants the <difference:
=(B1-A1)/A1 or =B1/A1 - 1
format as percentage

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Harald Staff" wrote in message
...
Hi

40 in A1. 80 in B1. In C1 formula
=A1/B1
format as percent numberformat and you may discover that 40 is 50% of 80.

HTH. Best wishes Harald

"cimarron trucking" <cimarron skrev i
melding ...
What function can I use/make to figure the difference in percentage
between 2
monetary amounts?