Results 1 to 7 of 7

Data VAlidation With If statement

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    Riyadh
    MS-Off Ver
    Office 365 Subscription
    Posts
    47

    Data VAlidation With If statement

    Consider i have an amount e.g. 100,000 in A1. Now this amount can be divided equally on 24 months or 36 months i.e. 100,000/24 or 100,000/36.

    I want to create formula that if i select 2 years in validation column( "A2" ) it Automatically divide the A1 value by relevant no of months and map the result monthly from January to December in appropriate columns. I have attached a sample file of what i want.

    Please have a look.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data validation and If statement
    By tjohans in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-29-2013, 05:20 PM
  2. DATA Validation and IF statement
    By NCAA in forum Excel General
    Replies: 3
    Last Post: 03-29-2012, 04:01 AM
  3. Data validation in if statement
    By mahoo in forum Excel General
    Replies: 3
    Last Post: 02-15-2011, 04:06 PM
  4. Data validation IF statement
    By christopherp in forum Excel General
    Replies: 4
    Last Post: 11-12-2009, 11:27 AM
  5. using the if statement with data validation
    By GreenMonster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2005, 04:06 PM

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