+ Reply to Thread
Results 1 to 1 of 1

Set Decimal Places in accordance to different set of value

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Set Decimal Places in accordance to different set of value

    Hi All,

    I am Bell. Nice to meet you all.This is my first post. A bunch of thanks to you all in advance for assisting me to resolve my problem.

    Currently I am working out an excel with Macro. Below is my difficulty I am encountering:

    Column A and Column E are interdependent with each other.

    Column A value: 201-231

    Column E:
    maximum of 2 decimal places if column A value >206
    maximum of 6 decimal places if column A value <206
    All the decimal places are rounding up for all the values.

    Enclosed is the sample of the excel.

    Many thanks.

    Kind regards,
    Bell
    Attached Files Attached Files

+ Reply to Thread

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