View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LinLin LinLin is offline
external usenet poster
 
Posts: 46
Default Percentage Variation - when values are zero

Hello Joeu

Thank you for that.

Yes, it was pointed out to me that I had my variance around the wrong way :-(
Sorry about that, and everyone who contributed.
I'll have a go at that. (More feedback to come....)


"joeu2004" wrote:

Errata....

On Nov 30, 8:27 pm, I wrote:
Actual Budget Variance Pct Below Budget


The last column should be "Pct of Budget", where negative means "%
less" and positive means "% more", as you had it.