| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Please Help!!!! Need help with formula.
I have blank cells that I replaced with "-". I have a formula using those cells, but it gives me #VALUE! INSTEAD OF "-". How do I get the formula to recognize "-" as zero? Thanks in advance for any help!
|
|
#2
|
|||
|
|||
|
Quote:
|
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Please Help!!!! Need help with formula.
Insert if statement to look at cell. ---if(cell='-',0,cell)
|
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Please Help!!!! Need help with formula.
Insert if statement into equation to check for dash.
If(cell='-', 0,cell) |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Please Help!!!! Need help with formula.
On Thursday, September 20, 2012 at 10:52:32 AM UTC-5, CNW wrote:
I have blank cells that I replaced with "-". I have a formula using those cells, but it gives me #VALUE! INSTEAD OF "-". How do I get the formula to recognize "-" as zero? Thanks in advance for any help! -- CNW if(cell="-",0,cell) |
|
#6
|
|||
|
|||
|
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula autofill to cells below – formula arguments are cell areas in different columns | Excel Discussion (Misc queries) | |||
| Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Hybrid Mode
