| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Ignore Symbols in a cell
In cell I4 I have the value (# 6) and in cell I10 I have just a number ...say
60. I would like to divide cell I10 by Cell I4. I get a value error. -- Geo |
|
#2
|
|||
|
|||
|
try
=SUBSTITUTE(i4,"#","")+2 -- Don Guillett SalesAid Software "Geo" wrote in message ... In cell I4 I have the value (# 6) and in cell I10 I have just a number ....say 60. I would like to divide cell I10 by Cell I4. I get a value error. -- Geo |
|
#3
|
|||
|
|||
|
=I10/SUBSTITUTE(I4,"# ","")
HTH Jason Atlanta, GA -----Original Message----- In cell I4 I have the value (# 6) and in cell I10 I have just a number ...say 60. I would like to divide cell I10 by Cell I4. I get a value error. -- Geo . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Hybrid Mode
