Results 1 to 3 of 3

Thread: Automatic percentage calculation of value but in the same cell value being entered

  1. #1
    Neophyte scorpio6ix's Avatar
    Join Date
    Dec 2021
    Posts
    1
    Articles
    0
    Excel Version
    2016

    Question Automatic percentage calculation of value but in the same cell value being entered



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I want the cell (in which I type some numerical value) to show a certain percentage of the entered value (say 40 %) but in the same cell instead of actual value entered. For example if I type let say 100 in the cell A1, the same cell should now show a certain percentage of the entered value (say 30 or 40 % whatever required) instead of showing the entered value. Like in cell formatting, we can program the cells to show the entered values in different styles/ways but underlying actual value remains same.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,061
    Articles
    0
    Excel Version
    365
    Not without vba (a macro).
    Cells A1:A10 will behave as you might want (the underlying value changes). Few checks and balances, no bells and whistles.
    Attached Files Attached Files

  3. #3
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,882
    Articles
    0
    Excel Version
    O365
    You can do it with the camera tool.

    Say your input is in A1 on Sheet1. In some other cell, say A1 on Sheet2, put the formula =Sheet1!A1*40%.

    Then you the camera tool to image that cell, and move the image over Sheet1 cell A1.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •