formulae problem confused?

[drag-driver]

i am testing a cell which contains either a number between 0 and 9 and if it contains zero to return true and return false if it contains 1:9 or if it is blank. The problem is it returns true not only when it contains zero but even if the cell is blank.

any help much apreciated

[nisht]

Sub selecttruefalse()

If IsEmpty(ActiveCell) Then
ActiveCell = False
Exit Sub
End If

Select Case ActiveCell
Case 1 To 9
ActiveCell = False
Case Is = 0
ActiveCell = True
End Select

End Sub


nishith desai
http://www.pexcel.com

[Mark W.]

On 2002-04-16 07:54, drag-driver wrote:
i am testing a cell which contains either a number between 0 and 9 and if it contains zero to return true and return false if it contains 1:9 or if it is blank. The problem is it returns true not only when it contains zero but even if the cell is blank.

any help much apreciated

=NOT(OR(A1,ISBLANK(A1)))

[ This Message was edited by: Mark W. on 2002-04-16 08:27 ]

[Aladin Akyurek]

On 2002-04-16 07:54, drag-driver wrote:
i am testing a cell which contains either a number between 0 and 9 and if it contains zero to return true and return false if it contains 1:9 or if it is blank. The problem is it returns true not only when it contains zero but even if the cell is blank.

any help much apreciated

=(LEN(A1)=1)*(A1=0)

produces either 1 or 0 instead of TRUE or FALSE repectively (1=TRUE,0=FALSE).

If you rather want to see a logical value as result, use:

=AND((LEN(A1)=1)*(A1=0))

Aladin