| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
##### in cells
How do I stop ##### from displaying in formula cells?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
##### in cells
Min
Widen the column or do not try and display negative times -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "Min" wrote in message ... How do I stop ##### from displaying in formula cells? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
##### in cells
My formula is based on subtracting the value of 2 different cells. If no data
has been entered into one of the cells then I get the #value! result. How can I either hide this or display it as some meaningful text. Can I use error.type? "Nick Hodge" wrote: Min Widen the column or do not try and display negative times -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "Min" wrote in message ... How do I stop ##### from displaying in formula cells? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
##### in cells
You have a few options:
One is to rewrite your formula: =if(count(a1:b1)=0,"",a1-b1) or =if(count(a1:b1)=0,"Please enter at least one number!",a1-b1) (=count() counts the quantity of numbers in that range.) Another option is to use format|Conditional formatting to hide the error. format|conditional formatting formula is: =iserror(c1) give it a white font on white fill (match the font color with the fill color) Min wrote: My formula is based on subtracting the value of 2 different cells. If no data has been entered into one of the cells then I get the #value! result. How can I either hide this or display it as some meaningful text. Can I use error.type? "Nick Hodge" wrote: Min Widen the column or do not try and display negative times -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "Min" wrote in message ... How do I stop ##### from displaying in formula cells? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions | |||
Linear Mode
