ST Alpha - "=IF(ISBLANK(B3)=FALSE,B3,IF(ISBLANK(A3)=FALSE,A3,"")) -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 154

In response to "Sorry, not Access. I mean Excel -- nm" by Bloody AxeSean

=IF(ISBLANK(B3)=FALSE,B3,IF(ISBLANK(A3)=FALSE,A3,"")) -- nm

Posted by decline (aka Decline) Oct 27 '09, 13:35

(No message)

Responses:

Hmm. no, that doesn't seem to work either. -- nm - Bloody AxeSean Oct 27, 13:38 3
- is the field truly blank, or may it contain spaces? because it seems to work on my excel. -- nm - decline Oct 27, 13:39 1
  - I didn't think it did, but it was a dump from an Access query. Maybe it was "not null" or something. - Bloody AxeSean Oct 27, 13:42
- his works fine for me -- nm - GWAA Oct 27, 13:39

Post a message top

Replies are disabled on threads older than 7 days.