thanks bob, first time i used this forum excellent result.

"Bob Phillips" wrote:

=(100-80)/100

and format as percentage,

or if the numbers are in A1 and A2 say

=(A1-A2)/100

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"conroy" wrote in message
...
how can i set the result of 100 minus 80 as a % of 100 using formulae in
excel