Results 1 to 4 of 4

Change the physical value of a cell instead of visual with roundup function

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2011
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    2

    Change the physical value of a cell instead of visual with roundup function

    Hello!

    I want to round up a value and use this value in vlookup function. When excel reads the cell he uses the underlying value.

    Example: 300/7 = 42,85714286
    H8=ROUNDUP(H7;2) = 42.86

    table
    42.85 X
    42.86 Y

    =vlookup(H8;"range";1;false) will return X and not Y

    I've tried trunc() as well, but doesn't work

    Can anyone help me with this problem?
    Last edited by MWI; 03-01-2013 at 12:11 PM.

Thread Information

Users Browsing this Thread

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

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