+ Reply to Thread
Results 1 to 2 of 2

Using the displayed value but not for whole spreadsheet

  1. #1
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    197

    Using the displayed value but not for whole spreadsheet

    Is there a way, without changing settings in toold_options_calculations, to get a displayed value to be used rather than the cell value?


    The cell value in A1 is 2.001475
    The displayed value is 2.001 as it is rounded that way.

    In cell A2 is a reference number, in this case simply 2.0

    Cell A3 is to show the difference between A1 and A2 after being multiplied by 1000.

    So Cell A3 should show 1 (rather than 0.001).

    What I'm getting however is the cell value rather than what it would be displayed (so I'm getting 1.475 instead of 1).

    I know you can change the settings of excel to calculate dsiplayed values, but I don't want to do it for all cells - just certain ones.

    Also the number of decimal places of A1 will vary so I can't just set cell A3 to a specific number of places.

  2. #2
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    197

    Re: Using the displayed value but not for whole spreadsheet

    Just to add, one way I think I may be able to do it might be using a round function using the length after the decimal place of the number in A1 minus 3?

+ 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