Graphical Indicator to show if outside budget

  • Thread starter Thread starter Mustang
  • Start date Start date
M

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
 
The Truncation, in this case, is not needed.
Micky
 
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.
 
Hi guys,

I have answered my own question:

If I write:

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

then it works

Thanks again
 
Back
Top