| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#value!
thanks teethless mama!
"Teethless mama" wrote: =IF(A1="","zero",your formula) "AFA" wrote: Hi all Cell Result Formula (672.00) (672) =--SUBSTITUTE(+$Cell,".",",") (10.00) (10) =--SUBSTITUTE(+$cell,".",",") #VALUE! =--SUBSTITUTE(+$cell,".",",") any idea if i need to change the result from "#Value! to "zero" if the cell is "nil" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
