Results 1 to 5 of 5

Data validation IF statement

Threaded View

  1. #1
    Registered User
    Join Date
    12-23-2003
    Location
    Perth, Western Australia
    Posts
    27

    Data validation IF statement

    Hi There

    I am trying to create a data validation rule that only allows a neagtive value to be entered if the word "backcharge" appears in an adjacent cell.

    So far I have come up with = if(d2="backcharge",<=0, .... But I am not sure how to finish it off.

    I am sure this is relatively simple problem but any help is greatly appreciated.

    Cheers

    Chris
    Last edited by NBVC; 11-12-2009 at 12:16 PM. Reason: Marked Solved based on Rep comments

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