LinkBack URL
About LinkBacks
taylorsm 
You can use all three conditions: =AND(ISNUMBER(A1),A1>0) . why three? because A1<>"" is included in A1>0
so if:
A1 = xyz (text) result = FALSE
A1 = 0 or -123 result = FALSE
A1 > 0 result = TRUE
check logical of AND function
You can use all three conditions: =AND(ISNUMBER(A1),A1>0) . why three? because A1<>"" is included in A1>0
so if:
A1 = xyz (text) result = FALSE
A1 = 0 or -123 result = FALSE
A1 > 0 result = TRUE
check logical of AND function
Last edited by sandy666; 03-17-2016 at 02:10 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks