Formula to create a variance percentage

C

Catherin

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
 
S

Suzanne S. Barnhill

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
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage of month passed formula 1
Cumulative formula for word table 0
Getting a formula to reflect added columns 10
formula for arriving net difference 0
Trying to figure the formula 1
Macro to insert and move columns 3
Crazy Variance Formula 0
Conditional SUM for Budget, Actuals, & Variance YTD columns 0

Top