Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoSum | New Users to Excel | |||
AutoSum Help | Excel Worksheet Functions | |||
autosum | Excel Worksheet Functions | |||
AutoSum | Excel Worksheet Functions | |||
AutoSum | Excel Worksheet Functions |