Results 1 to 3 of 3

Formula which gives error when more than 16 Characters entered

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2007
    Posts
    38

    Formula which gives error when more than 16 Characters entered

    Hi,

    I was wondering if anyone was aware of a formula which will allow an error message to pop up in a cell if more than 16 Characters are entered into another cell ?

    However, I cant put an actual limit on the characters for this cell as if another cell is populated with anything other than bacs then it can allow more than 16. Therefore my formula needs to state something like :

    =If(A1="BACS", If(B1=">16 characters", "TOO LONG", ""))
    If anyone can help I would be very grateful, thanks.
    Last edited by Newton1234; 01-16-2009 at 07:16 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1