autosum
 

I am trying to get the formula to give a % for an a propsed sum against an
actual sum, for instance if proposed was 14 and actual was 14 then the cell
should read 100% or if the proposed was 11 and the actual was 4 then the cell
would read 36%

autosum
 

Hi

Proposed in A1, Actual in B1. Formula in C1
=B1/A1
format as percent.

HTH. Best wishes Harald

"flowerp" wrote in message
...
I am trying to get the formula to give a % for an a propsed sum against an
actual sum, for instance if proposed was 14 and actual was 14 then the
cell
should read 100% or if the proposed was 11 and the actual was 4 then the
cell
would read 36%