| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Green arrow in cells
The formula *does* give the numbers as text. You can confirm it with
=ISTEXT(cell_ref). But note that you've got 2 conditions testing for $A9=20, so you won't get to the "020" value. -- David Biddulph wrote in message ... I need a addition to make this formula insert numbers as text =IF($A9=24,"",(IF($A9=20,"190", (IF($A9=20,"020",IF(ISBLANK(B9),"","")))))) any ideas Cheers JAck |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| green mark in the top left corner of cells | Excel Discussion (Misc queries) | |||
| How to get rid of green triangles from top-left corner of cells? | Excel Discussion (Misc queries) | |||
| Can i add up all green filled cells in a workbook? | Excel Worksheet Functions | |||
| How do I get excel to add cells by color? Like all green cells (s. | Excel Discussion (Misc queries) | |||
| I am getting Green triangle on one column in all the cells ? | New Users to Excel | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
