Results 1 to 3 of 3

Validation List with If statement

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2011
    Location
    New Hampshire, USA
    MS-Off Ver
    Excel 2007
    Posts
    36

    Question Validation List with If statement

    Hello, I have a validation list in columns E,F,I,L and M (No, Yes, N/A) I would like to put an if statement in columns F-M along with the validation list. So in F3 I would like to enter =if(E3="N/A","N/A"). Basically I would like if E2 = N/A than F2,I2,L2 and M2 are N/A. Any help would be appreciated. Thank you.



    Last edited by snikrs11; 03-04-2011 at 01:25 PM.

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