Graphical Indicator to show if outside budget
 

Hi there,

I am working in Excel 2003, I have 4 columns as below:
Budget Actual Variance Outside Budget
10000 15000 5000 #
10000 20000 10000 ##

Is there anyway I can set up a formula that will place a # in the Outside
Budget column for every $5000 that is over budget?

Many thanks

Graphical Indicator to show if outside budget
 

One way

=REPT("#", TRUNC(C2/5000))
--
HTH...

Jim Thomlinson


"Mustang" wrote:

Hi there,

I am working in Excel 2003, I have 4 columns as below:
Budget Actual Variance Outside Budget
10000 15000 5000 #
10000 20000 10000 ##

Is there anyway I can set up a formula that will place a # in the Outside
Budget column for every $5000 that is over budget?

Many thanks

Graphical Indicator to show if outside budget
 

This is all you need:
http://img690.imageshack.us/img690/3036/nonamed.png
Micky


"Mustang" wrote:

Hi there,

I am working in Excel 2003, I have 4 columns as below:
Budget Actual Variance Outside Budget
10000 15000 5000 #
10000 20000 10000 ##

Is there anyway I can set up a formula that will place a # in the Outside
Budget column for every $5000 that is over budget?

Many thanks

Graphical Indicator to show if outside budget
 

The Truncation, in this case, is not needed.
Micky


"Jim Thomlinson" wrote:

One way

=REPT("#", TRUNC(C2/5000))
--
HTH...

Jim Thomlinson


"Mustang" wrote:

Hi there,

I am working in Excel 2003, I have 4 columns as below:
Budget Actual Variance Outside Budget
10000 15000 5000 #
10000 20000 10000 ##

Is there anyway I can set up a formula that will place a # in the Outside
Budget column for every $5000 that is over budget?

Many thanks

Graphical Indicator to show if outside budget
 

Thank you all for your quick responses.

I have tried this and if I type the values, it works, but when I first tried
it with my values being the results of formulas I get a #VALUE error.



"מיכאל (מיקי) אבידן" wrote:

This is all you need:
http://img690.imageshack.us/img690/3036/nonamed.png
Micky


"Mustang" wrote:

Hi there,

I am working in Excel 2003, I have 4 columns as below:
Budget Actual Variance Outside Budget
10000 15000 5000 #
10000 20000 10000 ##

Is there anyway I can set up a formula that will place a # in the Outside
Budget column for every $5000 that is over budget?

Many thanks

Graphical Indicator to show if outside budget
 

Hi guys,

I have answered my own question:

If I write:

=(REPT("#",ABS(D2/5000)))

then it works

Thanks again


"Mustang" wrote:

Thank you all for your quick responses.

I have tried this and if I type the values, it works, but when I first tried
it with my values being the results of formulas I get a #VALUE error.



"מיכאל (מיקי) אבידן" wrote:

This is all you need:
http://img690.imageshack.us/img690/3036/nonamed.png
Micky


"Mustang" wrote:

Hi there,

I am working in Excel 2003, I have 4 columns as below:
Budget Actual Variance Outside Budget
10000 15000 5000 #
10000 20000 10000 ##

Is there anyway I can set up a formula that will place a # in the Outside
Budget column for every $5000 that is over budget?

Many thanks