Graphical Indicator to show if outside budget

[Mustang]

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

 

[Jim Thomlinson]

One way

=REPT("#", TRUNC(C2/5000))

 

[מיכ×ל (מיקי) ×בידן]

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

 

[מיכ×ל (מיקי) ×בידן]

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

 

[Mustang]

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.

 

[Mustang]

Hi guys,

I have answered my own question:

If I write:

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

then it works

Thanks again