| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indicator to show formula cell | Excel Discussion (Misc queries) | |||
| Best chart to show quarterly forecast vs budget | Charts and Charting in Excel | |||
| How to send worksheet so indicator will show with comments | Excel Discussion (Misc queries) | |||
| graphical indicator | Excel Discussion (Misc queries) | |||
| Divide Monthly Sales Budget to Day Budget | Excel Worksheet Functions | |||
Linear Mode
