Sign in to follow this  
Followers 0
D. S.

Data Validation in Excel

3 posts in this topic

Hello. I'm looking for some help with a situation I'm having in an Excel spreadsheet. I've used Data Validation before with success, but I can't seem to nail down the required formula for what I want.

 

Here's what I'm trying to do:

 

We have an Excel file that serves as a work log. Somebody does a certain task, they log it there in a 3 column system (A, B and C).

 

Column A describes the type of task and it is data validated against a List. You can only choose from 3 types of task: Documents, Faxes, and Phones.

 

The B column contains a small summary of the work done, no need for validation there.

 

The C column is where things get tricky. One of the mentioned tasks, Documents, requires that you also log the number of documents processed. I want to make it so that column can only be filled if the column A value corresponds to the correct task type and only a numerical value can be input (no text). Anything else, it should show an error.

 

I've tried using Data Validation with both AND and IF clauses but I just can't get it to work. Is what I'm asking doable? :s

Share this post


Link to post
Share on other sites

=AND(A1="Documents",ISNUMBER(C1)=TRUE) should be the data validation formula in Excel 2010 to do what you want. You may want to add further conditions such as C1 > 0.

Share this post


Link to post
Share on other sites

=AND(A1="Documents",ISNUMBER(C1)=TRUE) should be the data validation formula in Excel 2010 to do what you want. You may want to add further conditions such as C1 > 0.

 

That works :D . I can now see what I did wrong, shouldn't have used an IF clause to start it. Really need to brush up on my Excel.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.