Results 1 to 3 of 3

Choose the bigger or equal value

Threaded View

Blue_Wings Choose the bigger or equal... 03-07-2011, 02:05 PM
NBVC Re: Choose the bigger or... 03-07-2011, 02:22 PM
Blue_Wings Re: Choose the bigger or... 03-07-2011, 02:52 PM
  1. #1
    Registered User
    Join Date
    03-20-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2019
    Posts
    69

    Smile Choose the bigger or equal value

    Hi

    Good afternoon,

    Having a table with values starting of 400 to multiples of 400 liters, starting from 400 liters in A1 and the A30 end up in a row with 12,000 liters.

    (Colum A1)
    400
    800
    1200
    1600
    2000
    2400
    2800
    3200
    3600
    4000
    4400
    4800
    5200
    ...
    (all the rest multiples ultil 12000)
    If I have a value of 510 liters imput in cell C1, I want to appear in cell D1 the value of 800 liters (ie where the value exceeds the value imput line in column A that always takes the next value, which as is 400 in 400 assumed the value ->800)?

    Another example: If you have the value 890 in C1 to assume the value of 1200 in D1. (Always assume the next highest value of colum A)

    Another example: If C1 has exactly one of the assumed values of 400 multiples as A then takes the same value in D1.
    If it is C1 6800 D1 6800 is because it is according to the exact value of table A17.

    If anyone can help i will appreciate
    Thanks
    Last edited by NBVC; 03-07-2011 at 03:54 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