Results 1 to 8 of 8

Data validation with limit

Threaded View

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

    Data validation with limit

    Total amount payable is 24,000

    Monthly installment varies. from 1100 to 2550.

    If i select 1100 in cell c4 it should show the same intallemnt across whole of row 4 till it reach maximum amount i.e. 24000. And in the last cell it should show any residual instead of complete installment.

    Example attached
    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 to limit quantity for certain items
    By flacag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2011, 02:18 PM
  2. Excel 2007 : Data Validation Character Limit
    By Magsy in forum Excel General
    Replies: 3
    Last Post: 09-12-2011, 05:09 PM
  3. Limit Data Validation List
    By mattblades in forum Excel General
    Replies: 4
    Last Post: 08-01-2011, 11:33 AM
  4. Data Validation - character limit
    By kinobi-kid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2009, 12:32 PM
  5. [SOLVED] Range name limit for data validation
    By Paul K. in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-09-2005, 11:06 AM

Tags for this Thread

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