| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#value!
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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value!
If(iserror(A),"zero",A)
"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" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value!
=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" |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#value!
thanks minli.
"minli" wrote: If(iserror(A),"zero",A) "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" |
|
#5
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 | |
|
|
Linear Mode
