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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Larry Davsko
    Replies:
    1
    Views:
    100
    Doug Robbins - Word MVP
    Jul 9, 2003
  2. Maggie

    Division or percentage formula

    Maggie, Feb 13, 2004, in forum: Word Tables
    Replies:
    1
    Views:
    86
    Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT
    Feb 13, 2004
  3. J Kimble
    Replies:
    1
    Views:
    75
    Doug Robbins
    Aug 12, 2005
  4. Jams
    Replies:
    1
    Views:
    80
    Herb Tyson [MVP]
    Aug 15, 2005
  5. Betsy

    Display Percentage sign in word table

    Betsy, Aug 28, 2007, in forum: Word Tables
    Replies:
    5
    Views:
    92
    Betsy
    Aug 30, 2007
  6. Purplejopeg

    Percentage in form field

    Purplejopeg, Oct 17, 2007, in forum: Word Tables
    Replies:
    2
    Views:
    71
    Purplejopeg
    Oct 18, 2007
  7. NVC-V.I.P
    Replies:
    1
    Views:
    70
    Doug Robbins - Word MVP on news.microsoft.com
    Mar 10, 2009
  8. Briggs

    percentage

    Briggs, Apr 24, 2009, in forum: Word Tables
    Replies:
    3
    Views:
    74
    Suzanne S. Barnhill
    Apr 27, 2009
Loading...