how can i set the result of 100 minus 80 as a % of 100 using formulae in excel

=(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

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

I assume you mean this

=(100-80)/100

formats result as percentage


Regards,

Peo Sjoblom

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

A1=80%
B1=1-A1

result is automatic at 20%

--
*****
birds of the same feather flock together..



"conroy" wrote:

how can i set the result of 100 minus 80 as a % of 100 using formulae in excel