Formula to create a variance percentage

Discussion in 'Word Tables' started by Catherin, Jun 22, 2012.

  1. Catherin

    Catherin Guest

    I have a table with many columns.

    Let's say column F is YTD Actual and column G is Budget. The % Varianc
    column is H.

    I need a formula for word that will calculate the variance in percentag
    format.

    Can this be done?

    I tried an excel formula and it didn't work


    --
    Catherin
     
    Catherin, Jun 22, 2012
    #1
    1. Advertisements

  2. If you can't do it in Excel, the likelihood that you can do it in Word is
    very small. If you mean that you tried to use in Word the formula that you
    would use in Excel, then that won't work, either, because Word is not Excel.
    What is the formula you tried?

    --
    Suzanne S. Barnhill
    Microsoft MVP (Word)
    Words into Type
    Fairhope, Alabama USA
    http://word.mvps.org

    "Catherin" <> wrote in message
    news:...
    >
    > I have a table with many columns.
    >
    > Let's say column F is YTD Actual and column G is Budget. The % Variance
    > column is H.
    >
    > I need a formula for word that will calculate the variance in percentage
    > format.
    >
    > Can this be done?
    >
    > I tried an excel formula and it didn't work.
    >
    >
    >
    >
    > --
    > Catherin
    >
     
    Suzanne S. Barnhill, Jun 22, 2012
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.